Tags: SQL query

SCCM 2012 SQL Query count updates from Software update groups if they are bigger than hard limit 1000 or not

Posted on November 17, 2015 by | 0 Comments | 2,573 Views
In Configuration manager 2012,the update limit per update-deployment group has been increased (hard limit) to 1000 where was in Configmgr 2007,it was just 500 updates.More information about the hard limit and further questions ,worth reading the blog post by Kevin http://blogs.technet.com/b/server-cloud/archive/2012/02/20/managing-software-updates-in-configuration-manager-2012.aspx The hard limit is --the list of software updates what you see in software…
Read more »
sccm 2012 SQL Query Get software updates that are downloaded but not in any software update group

Posted on November 17, 2015 by | 1 Comment | 4,049 Views
Software update groups in Configmgr 2012 simplifies lot of administrative work ,which simply  contains list of updates (must be downloaded before you add any updates) merged to single deployment (can have multiple deployments for single software update group). Coming to the subject line, It is necessary (during cleanup activity) to find software updates that are…
Read more »
SCCM Configmgr 2012 How to Extract information from XML file stored in SQL DB for application properties

Posted on May 21, 2015 by | 11 Comments | 10,709 Views
  Last week,I was working on request to get the application information which includes Application Name ,Deployment Type ,Content location,Command lines (install and uninstall),what type of deployment is it,detection type,user requirement  and other information. Since there are no default reports to get this kind of information ,you must consider writing new SQL/SSRS report else go…
Read more »
SCCM Configmgr 2012 SSRS Report Count MS Office Versions

Posted on January 22, 2015 by | 31 Comments | 14,469 Views
  Recently , I worked on MS Office upgrade project to 2013 and before I take any action on this,I need to identify /get count of all MS Office Versions installed on the computers that are managed by Configuration manager 2012. There is no default Configmgr report that provide you this information ,so you must…
Read more »

Posted on December 18, 2014 by | 3 Comments | 5,640 Views
This is quick post on how to get list of Applications that are deployed to users requires approval . more Details ,refer https://social.technet.microsoft.com/Forums/en-US/644ff540-4eb0-49b6-97f4-094cada74c6a/viewing-deployments-that-require-approval?forum=configmanagerapps Run the following SQL query to know apps that require Approval. select app.displayname [Application Name],app.manufacturer [Manufacturer],app.numberofdeviceswithapp [No of Devices with this App],app.numberofuserswithrequest [No of Requests] from fn_ListApplicationCIs(1033) app, v_UserTargetedApps uta where uta.ci_id=app.ci_id…
Read more »

Posted on June 16, 2014 by | 0 Comments | 2,607 Views
Question from configmgr technet forum : Need SQL Query for disk space <500 MB (windows drive) for servers from most recent 10 records. Whenever there is any such request on reporting ,i always make use of SQL views documentation https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b. This excel sheet contains list of all SQL view+some functions that would help you to…
Read more »

Posted on February 11, 2014 by | 10 Comments | 1,773 Views
This is updated post for long ago blogged post http://eskonr.com/2010/04/sccm-reportcollection-for-computers-with-internet-explorer-with-different-versions/. are you in search of getting summary of IE Versions ,so that you can plan for the migration of Old IE Versions to current version ? Below is the SSRS/SQL report which will help you to get count of IE Versions and total. SQL Query…
Read more »

Posted on July 30, 2013 by | 0 Comments | 291 Views
Are you Migrating your Existing SCCM /Configuration Manager Infrastructure to Configuration manager 2012 ,if so, You will have to look at your Packages whether  they UNC path or Local Drive Path since Migration of Packages using Local Drive(Non UNC) can not done. Before you Migrate the Packages from CM07,you will have to ensure all of…
Read more »