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 months.
If you are having multiple OU's and if you have asked to get the patch compliance status based on the OU Wise per Update Group ,how would you get ? The default report doesn't deal with such a requirement and you are required to create custom report.
It took few hours for me to identify the right views from excel spread sheet that store the information about software update group and its compliance results.
For this requirement (report based on OU ), I need to know the view for software update group and its compliance status info.
Software update group info stored in v_AuthListInfo and compliance results stored in v_Update_ComplianceStatusAll
I created 2 nice SSRS reports 1) count computers with success,not success status and 2) linked report to drill down to see the computer names ,its recent HW Scan,Software Scan etc.
Download the 2 SSRS Reports from TechNet Gallery ,upload to your SSRS Folder ,change the Data source and run the report.
Report:
You need to look at the unknown status clients since they did not report anything about the software update scan ,could be that software update component not functioning correctly or for different reasons.
6 Comments
Pingback: SCCM ConfigMgr Compliance status of client for multiple software update groups | Eswar Koneti Blog
Have you thought about adding OS with percentages also?
Hi Joseph,
No, not at the moment but will be added to TO-DO list .when time permits ,i will take a look at them.
Regards,
Eswar
Pingback: Troubleshoot client side software updates issue. | system center experts
Superb, This is what i was always looking for But can instead of OU we have Collections ?
for collection,there is default report and for OU,there is no such one.