Tags: SQL

SCCM Configmgr 2012 Software update compliant non-compliant results for list of computers from collection for specific month

Posted on October 14, 2015 by | 11 Comments | 5,585 Views
Few days ago ,I was working on request to get the software update compliance (compliant /Non-Compliant) for list of clients (Desktops or servers) from collection for specific month.I have posted lot of Configmgr 2012 SSRS reports on my blog http://eskonr.com/tag/sccm-patch-reports/about software update compliant but this is something different compared to other reports. Due to the…
Read more »
SCCM Configmgr 2012 SSRS Report How to check content is used in what task sequences before cleanup using Cascading Parameters

Posted on July 6, 2015 by | 0 Comments | 2,718 Views
Recently I was doing some content cleanup (mainly for images) in Configmgr 2012 R2 .I have found lot a images for each OS (windows 7,Windows 8 and Windows 8.1) with different versions ,especially for windows 10 .Before I delete ,I was looking for some default report to check if any of these old versions are…
Read more »
SCCM Configmgr 2012 SSRS Patch Compliance Report Per Collection Per Update Group

Posted on January 21, 2015 by | 23 Comments | 28,674 Views
In order to check the Patch compliance/Deployment status,there are some default reports ,one of the widely used report to know the compliance status for specific Update group on specific collection is –>Compliance 1-Overall Compliance. But the sub report /drill down/Linked report to view the list of non complaint computers do not provide you the required…
Read more »
SCCM Configmgr 2012 SSRS Report Overall Compliance Per Update Group Per Collection will help to troubleshoot the clients

Posted on November 26, 2014 by | 1 Comment | 4,380 Views
Over the past few weeks,I posted several patch Compliance reports because ,the default report do not meet the requirements what I need thus ,created custom reports that would help the team to analyze the patch Statistics and troubleshooting non compliant machines. Software update compliance report month Wise: http://eskonr.com/2013/11/sccm-configmgr-2012-patch-compliance-summary-report-month-wise/ Software update Compliance report month Wise for…
Read more »
SCCM Configmgr 2012 Patch Report – OU based Compliance status per Update Group

Posted on November 4, 2014 by | 6 Comments | 10,989 Views
Question asked in the forum ,if it is possible to get patch compliance /deployment status report (installed,required,not applicable and unknown) based on OU for specific software update group instead of collection. Long ago,I posted patch compliance report for specific collection month wise http://eskonr.com/2014/09/configmgr-2012-summary-of-patch-compliance-status-report-month-wise-for-specific-collection-ssrs-report/ but it gives you overall compliance for each month for past 12…
Read more »