Configmgr 2012 summary of Patch Compliance status Report month wise for specific Collection SSRS report

Last year i wrote blog post on summary of patch compliance status report --month wise and am sure ,it would helped many of Configmgr guys who are responsible for patching and to let security /management know whether they met the company SLA for each month or not.

I have received couple of comments for my previous blog post ,asking for ,is there way to limit this report to specific collection instead of all active clients .My previous report get the compliance status for all active clients in Configmgr irrespective of ,whether you manage the patching for all clients or not.

There are cases ,where in,you are not supposed to patch some of the clients (workstations\servers) for different reasons and you are requested to get the patch compliances only for specific clients.

This blog post is about,how to limit the report to specific collection.



Download the RDL file from TechNet gallery ,upload to your SSRS report folder.

Don't forget to change the Data Source after you upload. If you want to know How to change the DataSource, refer

8 Responses to "Configmgr 2012 summary of Patch Compliance status Report month wise for specific Collection SSRS report"

  1. Hi, Very nice report.

    But the report does not work with Windows Server 2016 unfortunately. It might be because Security updates is classified as "Critical Updates" and not as "Security Updates". Do you know how this can be fixed?

    1. Hi KJ,
      I havent check for server 2016 as i do not have any server 2016 but i will get 1 server install and try this report ,which might take little time.


  2. Happy Diwali ESWAR.
    Can we have report in place which show in software update group how mainy were Sevurity update /Sumalative update and there compliance percentage,

  3. this is an excellent report that i was looking for to report to my mgmt. But for some reason the server count is not reading correct. I have 1620 servers in a collection that i am running report against, it is listing only 1545. Also i tired the query in sql studio, it is 1545. am not sure what is wrong and where to start troubleshooting. We did patched in Aug and the compliancy was 98%. this report is giving as 3.29%. Not sure if you can help.

    1. you can check the built in report (software update Compliance for specific update group and collection) to know what machines not compliant and then start troubleshooting .


Leave a Reply