Tags: patch compliance report

SCCM Configmgr 2012 SSRS Patch Compliance Report Per Collection Per Update Group

Posted on January 21, 2015 by | 23 Comments | 28,118 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,236 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,743 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 »
Configmgr SSRS Report Patch Compliance Statistics Last 30 days

Posted on February 14, 2014 by | 7 Comments | 2,961 Views
Year ago,I created CM07 report to know the patch compliance stats for active patches last 30 days.More info can be found from here.But this report was for configuration manager 2007 which will not work with Configmgr 2012 due to the changes in storing the information in SQL tables/Views. I have created similar report for configuration…
Read more »
SCCM Patch compliance Report Last 1 month for specific Collection

Posted on December 14, 2012 by | 13 Comments | 8,703 Views
Update: SSRS Report for Configuration manager 2012 (all Versions) is available on http://eskonr.com/2014/02/configmgr-ssrs-report-patch-compliance-statistics-last-30-days/ In my previous blogs,I posted couple of reports for Patch compliance status based on the KB/MS ID numbers . SCCM Patch Compliance Progress report:  http://eskonr.com/2009/10/patch-status-compliancesoftware-updates-report-in-sms-sccm/ Software Update Compliance Status on Specific Collection : http://eskonr.com/2009/09/report-for-software-update-report-for-software-update-compliance/ SCCM monthly Patch statistics report http://eskonr.com/2011/10/sccm-monthly-patch-statistics-reports-to-the-management-in-a-simplified-manner/ This report is going to…
Read more »

Posted on December 14, 2012 by | 1 Comment | 2,189 Views
When you deploy software updates using SCCM/configmgr to clients ,patch status will be sent back to SCCM site.It is always good to know the Last state ID's and its state names for custom reporting. Below are the available Last state ID's and State Names. These state IDs do exist in SQL View called v_GS_PatchStatusEx .   LastState LastStateName…
Read more »