Patch Compliance Progression by Collection

October 2020’s free Microsoft Endpoint Manager Configuration Manager (ConfigMgr/SCCM/MEMCM) giveaway is the Patch Compliance Progression by Collection report. This report is available in both Power BI and SSRS formats.

You might remember that we gave away this report in August 2017, and ever since then, we keep receiving numerous requests for it! Why is it so popular? This report identifies exactly what updates are missing on each computer. By the way, you may have seen this idea on our Ideas Page, and maybe you even voted for it, but this wasn’t a new idea – the Patch Compliance Progression report already existed!

What’s new in the 2020 version? The performance of this report is significantly improved. You will notice it right away! We also created a brand new Power BI report. Plus, in both the Power BI and SSRS versions, we made it easy to sort computers by the number of missing patches. Keep reading to find out more!

Patch Compliance Progression


Understanding what software updates (SU) are required or are already installed on each computer is very challenging. This task becomes even more complicated when you need to know whether or not all of the SU were applied in a Software Update Group (SUG). Service-level agreements (SLA) often state that you must achieve a “X” percent compliancy rate before a given number of weeks after a deployment. How can you easily tell which computers are not up-to-date in a given SUG? This is particularly tough when you have a 4+ week deployment cycle for SU.

Now, let’s talk about working from home (WFH). Hasn’t WFH just increased the need for more and better reporting? Where do you turn to for help? You can look at the ConfigMgr/SCCM built-in reports, as some are useful, but their layout and their details leave you wondering, “Which computer should I start with first? Which computer has the most risk?”

Solution: Patch Compliance Progression by Collection

Enhansoft’s Patch Compliance Progression by Collection report provides you with a count of missing software updates (patches) and the last hardware inventory date for each computer within a collection.

The classification report parameter enables you to multi-select which software update classification to display within the report. The update classifications are listed here in order of severity: Critical Updates, Security Updates, Definition Updates, Service Packs, Update Roll-ups, Updates, Tools, and Feature Packs. Click here to read more about update classifications. By default, all software update classifications are selected.

You can also multi-select different Software Update Groups (SUGs) and choose (All Software Updates) with the prompts in this report. The (All Software Updates) prompt is a catch-all list of all SU, even ones not applied to a specific SUG. Multi-selecting different SUGs allows you to compare SUGs and it helps you to notice whether or not computers in a certain SUG need SU.

You need all of these features in a report in order to ensure compliancy!

There’s also a bonus feature within the SSRS report which is particularly useful when the results are exported to Excel. In order to sort the “Status” column, the phrase, “Needs x Patches,” is not helpful if you want to look at computers with the most needed patches first, so we’ve solved that problem. In the top-left corner of the table, next to the “Computer” column header, there is a toggle switch. When you click on it, the “Status” column displays just the number of software updates missing and removes the text. This suggestion was another idea submitted to our Ideas page, so thank you!

In the full set, you can review the software updates for a specific computer by clicking on the computer’s name and drilling through to the Computer Software Update Details report.

One of the best parts about the SSRS report version is that, not only can you export it to a PDF and print it (the columns all fit on one page) but you can setup an email subscription to this report. Once a subscription is setup, the report is emailed to you at scheduled times. This feature is also available in a number of Enhansoft Reporting’s dashboards/reports. For more information about how to setup an email subscription, please see this post,

Power BI

Patch Compliance Progression - Power BI Report

SSRS – Default View

Patch Compliance Progression - SSRS Report - Default View

SSRS – Alternate View

Patch Compliance Progression - SSRS Report - Alternate View

Patch Compliance Progression

Enhansoft Reporting – Patch Compliance Progression by Collection

The Patch Compliance Progression by Collection report is found within Enhansoft Reporting’s Software Updates category. This category of dashboards and reports provides you with the ability to quickly and reliably determine the software update status of computers within your environment. You can even have these dashboards and reports emailed to administrators at scheduled times!

Would you find it useful to know which computers are your biggest security risks? Then get the Patch Compliance Progression by Collection report NOW!

Are you looking for another ConfigMgr/SCCM/MEMCM report? Are you looking for Power BI reports? Do you find that Configuration Manager reporting is difficult? Reporting shouldn’t be hard and with Enhansoft Reporting’s 150+ reports, sorted into 26 different categories, we make it easy for you!

Find out more about the reports in Enhansoft Reporting by clicking on any of the 26 category buttons below.

Still not sure that we have the right report for you? Just ask and we will be more than happy to help you out! Send a note to

All of our free reports have the Role-Based Administration (RBA) feature enabled. This means that whether you are using Configuration Manager Current Branch or System Center 2012 R2 Configuration Manager, these reports will work with all RBA settings.

Do you have an idea for a report set that you would like us to create? Submit them to our Ideas page, or drop us a line on Facebook or Twitter!

Patch Compliance Progression

Leave a Comment

Download a Software Update - PropertiesSchedule ConfigMgr Inventory - Task Scheduler
Share via
Copy link