Category: SCCM 2007

SCCM Configmgr SQL query to find Top X missing updates for specific collection for specific update group

Posted on August 22, 2016 by | 12 Comments | 11,115 Views
Since few days ,I am working on a customized Software update compliance dashboard report with some Pie charts for management to see how the patch compliance progress for each Business Unit (I say business unit means for each country). Management are interested to see the overall patch compliance summary for each country (focused on servers…
Read more »
SCCM Configmgr identify count of Direct membership rules ,collection Schedule Refresh Types

Posted on April 1, 2016 by | 2 Comments | 3,536 Views
Collections in Configmgr play a crucial role .If you want to do anything(can be software deployment,OSD ,Client agent settings,Software updates,compliance etc) in configmgr against clients,you a collection . Being Configmgr administrator, it is always important to look at collection performance ,if they are scheduled well and do some maintenance like identifying collections that take longer…
Read more »
SCCM list all default and Custom reports with created by, modified by, data source , Path

Posted on February 10, 2016 by | 0 Comments | 2,163 Views
By default,when you install Configmgr Reporting services point role,it create lot of reports with NT AUTHORITY\SYSTEM  account and this information can be seen from log called ‘srsrp.log’ on your Site system server.If you look at srsrp.log,there will be lot of information tracked along with list of reports it created ,its path (web path) etc. If…
Read more »
Configmgr SSRS SQL Query How to check Client is member of what collections and its Maintenance Window

Posted on February 5, 2016 by | 4 Comments | 831 Views
  This is quick post on How to check Client is member of what collections and display its Maintenance window . Maintenance Window information for collections are stored in view called v_ServiceWindow .Here is the excel spreadsheet that I always make it as reference for any custom queries always help to find right view. http://eskonr.com/2013/10/download-sccm-configmgr-2012-r2-sql-views/ …
Read more »
SCCM Configmgr How to generate patch compliance report that shows all updates for specific collection ?

Posted on February 4, 2016 by | 24 Comments | 40,094 Views
There are couple of posts on TechNet blog and other forums asking for ‘Is there any report that list all updates with compliance status for specific collection’ ? Read it once again ,A software update compliance report that list all updates whether Targeted, Installed, Missing for specific Collection. A collection may contain X number of…
Read more »