SCCM Configmgr Report How do I quickly check if Clients are compliant or not

Another interesting report  on software update compliance which will really helps lot of people in their daily job . Did you ever receive any requests to report compliance status(in one line report) for bunch of clients for ex: specific collection ? Management or Security guys

5 Star
2,699 times
Add to favorites
System Center
E-mail Twitter Digg Facebook
  • List the update titles for approved updates and IsRequired updates
    1 Posts | Last post October 26, 2018
    • Hi Eswar,
      Thanks for the report, how do i get an overview based on this view with titles of the approved updates and an overview with the titles for the required updates for a collection?
      I tried to modify your script but i didn't get the result i wanted. Thanks in advance.
      kind regards,
  • Missing workstations...
    1 Posts | Last post June 30, 2017
    • So I've implemented this report into our SSRS and it runs great and I understand how it works and it does exactly what I need. However, its missing a bunch of systems. For example, My "All Systems" collection contains just over 5,000 workstations. When I run the report or the query directly against SQL it only returns 3,561 rows. I've tried messing with the joins and where clauses but I'm still not getting close to the right numbers. Any idea's? Even if there is something wrong with the clients I'd still like to see them listed to know to take action.
  • Adding *Category to the report.
    1 Posts | Last post May 19, 2017
    • Hi Eswar,
      This is exactly what we need at the organization - but a quick question, is it possible to add/restrict further by *category (Check box on Critical Updates, Security updates, Updates etc) so we have a more accurate report on the missing critical/security updates missing as opposed to all category.
      The quick Compliance would now be for Collection Name and Category.
  • Need help tuning
    2 Posts | Last post March 03, 2017
    • I want to include this report on a webpage so I want to remove the prompt for a collection. I want to hardcode a specific collection in the rdl, how do I do that?
    • Hi Roel,
      download the RDL file, open with report builder or visual studio or any other reporting tool ,replace the @collID prompt with static Collection ID that you want to generate report for.