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.

 

image

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 http://be.enhansoft.com/post/2010/08/26/How-to-Change-the-SSRS-Datasource.aspx

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

  1. 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,

    Reply
  2. 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.

    Reply
    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 .

      Reply

Leave a Reply