We help you save time, money and improve your IT security

Integrate Third-Party Patch Management in Microsoft ConfigMgr and Intune

Free SSRS Software Update Dashboard for Microsoft SCCM

An important aspect of patch management in System Center Configuration Manager is to be able to report on update compliance easily and accurately. Many of the native reports available in SCCM aren’t easily understood.

Our team has updated and created a simple install for the dashboards created originally from Microsoft employee Gary Simmons. These reports are free to use.

Topics covered in this article:

More InformationUpdate: In addition to the free SSRS dashboards below, we also offer a free Power BI report for Microsoft and third-party updates in Configuration Manager.

How to Install the SSRS Software Update Reports:

  • Step 1: Download the Publisher MSI and install it
  • Step 2: Click the button “Run Report Installer…” in the Advanced tab of the publisher
  • Step 3: Enter the details for your SSRS reporting instance:
    • ConfigMgr Root SSRS Folder
      • SSRS Reports Get ConfigMgr SSRS Folder Name
    • ConfigMgr SQL Reporting Server 
      • ConfigMgr SSRS Server Name
    • The “SSRS Folder to UPload Reports to:” can be left as default
    • The default value for “SSRS Report Manager Folder:“, will generally be correct, but if you use a custom report manager folder name you will need to change it.
      • SSRS Report Manager Folder
    • The “SSRS Web Service Folder“, will generally be correct, but if you use a custom web service folder name you will need to change it.
      • SSRS Web Service URL
  • Step 4: Click “Start Report Install” and a Powershell script will automatically change the report URLs, and upload the reports to your SSRS server.
    • SSRS Report Upload Script

Known Issue with Slow Loading and Resolution:

Depending on the SQL Server version and Configuration Manager version, you may see slow report loading or timeouts on some reports. This is a known issue that can occur when the SQL compatibility level is set higher than 110SQL query times out or console slow on certain Configuration Manager database queries

Overview of Each Report:

01 - Software Update Dashboard

This report is one of the main software update dashboard reports. This report shows overall update compliance information for a specific collection of devices. This report has many clickable links to drill down to sub-reports. Assets Section: This list the number of workstations and servers in the environment.

    • UnManaged = Machines that haven’t performed a software update scan in the last 14 days
    • Managed = Machines that have performed a software update scan in the last 14 days
    • Total = The count of UnManaged and Managed
    • Clickable Links: Servers and Workstations

Software Update Dashboard - Assets

Software Update Information: This list of percentages of updates installed for a specific month.

  • Count under each month = Number of applicable (Required or Installed) updates for each month
  • Percentage number = Percentage of updates for compliance on machines for each month
  • Clickable Links: The Chart Titles, Percentage Numbers, and Bar Graphs

Software Update Dashboard - Software Update Information

Workstation Compliance: This shows the workstation compliance for different scenarios.

  • Overall Compliance Chart: This shows the percentage of Windows 7, Windows 8.1, and Windows 10 that are 100% compliant for all available updates.
  • Workstations Missing Software Updates Chart: This chart list the number of machines missing a specific number of updates: 1-10, 11-25, 26-50, >50.
  • Percentage of Workstations 100% Compliance by Month Chart: This chart shows the percentage of Windows 7, Windows 8.1, and Windows 10 machines that are 100% compliance for all updates in a specific month.
  • Workstations Missing At Least 1 Update By Month Chart: This shows the count of Windows 7, Windows 8.1, and Windows 10 devices missing at least 1 update for a specific month.
  • Clickable Links: Workstations, Percentage Numbers, Bar Graphs, Counts

Software Update Dashboard - Workstation Compliance

Server Compliance: This shows the workstation compliance for different scenarios.

  • Overall Compliance Chart: This shows the percentage of Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2 that are 100% compliant for all available updates.
  • Servers Missing Software Updates Chart: This chart list the number of machines missing a specific number of updates: 1-10, 11-25, 26-50, >50.
  • Percentage of  Servers 100% Compliance by Month Chart: This chart shows the percentage of Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2 machines that are 100% compliance for all updates in a specific month.
  • Servers Missing At Least 1 Update By Month Chart: This shows the count of Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2 devices missing at least 1 update for a specific month.
  • Clickable Links: Servers, Percentage Numbers, Bar Graphs, Counts

Software Update Dashboard - Server Compliance

02 - Third-Party Update Dashboard
This report is one of the main software update dashboard reports. This report shows overall third-party update compliance information for all devices in the environment. This report has many clickable links to drill down to sub-reports. Assets Section: This list the number of workstations and servers in the environment.

  • UnManaged = Machines that haven’t performed a software update scan in the last 14 days
  • Managed = Machines that have performed a software update scan in the last 14 days
  • Total = The count of UnManaged and Managed
  • Clickable Links: Servers and Workstations

Software Update Dashboard - Assets Software Update Information: This list of percentage of updates installed for a specific month.

  • Count under each month = Number of applicable (Required or Installed) updates for each month
  • Percentage number = Percentage of updates that for compliance on machines for each month
  • Clickable Links: The Chart Titles, Percentage Numbers, and Bar Graphs

Software Update Dashboard - Software Update Information Workstation Compliance: This shows the workstation compliance for different scenarios.

  • Overall Compliance Chart: This shows the percentage of Windows 7, Windows 8.1, and Windows 10 that are 100% compliant for all available updates.
  • Workstations Missing Software Updates Chart: This chart list the number of machines missing a specific number of updates: 1-10, 11-25, 26-50, >50.
  • Percentage of Workstations 100% Compliance by Month Chart: This chart shows the percentage of Windows 7, Windows 8.1, and Windows 10 machines that are 100% compliance for all updates in a specific month.
  • Workstations Missing At Least 1 Update By Month Chart: This shows the count of Windows 7, Windows 8.1, and Windows 10 devices missing at least 1 update for a specific month.
  • Clickable Links: Workstations, Percentage Numbers, Bar Graphs, Counts

Software Update Dashboard - Workstation Compliance Server Compliance: This shows the workstation compliance for different scenarios.

  • Overall Compliance Chart: This shows the percentage of Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2 that are 100% compliant for all available updates.
  • Servers Missing Software Updates Chart: This chart list the number of machines missing a specific number of updates: 1-10, 11-25, 26-50, >50.
  • Percentage of  Servers 100% Compliance by Month Chart: This chart shows the percentage of Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2 machines that are 100% compliance for all updates in a specific month.
  • Servers Missing At Least 1 Update By Month Chart: This shows the count of Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2 devices missing at least 1 update for a specific month.
  • Clickable Links: Servers, Percentage Numbers, Bar Graphs, Counts

Software Update Dashboard - Server Compliance

03 - SUG Compliance - Dashboard
This report is one of the main software update dashboard reports. This report shows overall third-party update compliance information for all devices in the environment. This report has many clickable links to drill down to sub-reports.

Assets Section: This list the number of workstations and servers in the environment.

  • UnManaged = Machines that haven’t performed a software update scan in the last 14 days
  • Managed = Machines that have performed a software update scan in the last 14 days
  • Total = The count of UnManaged and Managed
  • Clickable Links: Assets

03 - SUG Compliance - Dashboard - MachinesWorkstation Compliance: This shows the workstation compliance for different scenarios.

  • Systems Missing Software Updates Chart: This chart list the number of machines missing a specific number of updates: 1-10, 11-25, 26-50, >50.
  • Clickable Links: Workstations, Percentage Numbers, Bar Graphs, Counts

03 - SUG Compliance - Dashboard - MachinesOverall Compliance: This shows the workstation compliance for different scenarios.

  • Overall Compliance Chart: This chart shows the overall compliance for updates that are either installed or required for a specific software update group.
  • Clickable Links: Bar graph

03 - SUG Compliance - Dashboard - Overall Compliance

Overall Compliance: This shows the workstation compliance for different scenarios.

  • Applicable Software Updates Chart: This chart shows the overall compliance for updates that are either installed or required for a specific software update group for the last 12 months by month.
  • Clickable Links: Bar graph for each month

03 - SUG Compliance - Dashboard - Applicable Updates by Month

04 - All Software Updates Missing By Collection
This report allows you to choose a collection and a specific software update group and review the compliance results by machine.

  • Update Severity: Critical, Important, Moderate, Low, and None
  • Clickable Links: Computer Name

Missing Software Updates By Collection [/expand][expand title=”04 – Installed Third-Party Applications” tag=’h2′] This report allows you to choose a specific application from the applications in our SCUP catalog and show how many unique versions are installed in the environment.

  • Clickable Links: Display Name and Display Version

Application Version Report

05 - Installed Third-Party Applications
This report allows you to choose a specific application from the applications in our SCUP catalog and show how many unique versions are installed in the environment.

  • Clickable Links: Display Name and Display Version

Application Version Report

Sub - All Software Updates Missing By Device
This report is a sub-report of 03 – All Software Updates Missing By Collection. This will show all the updates missing by a specific device.

  • Clickable Links: URL

Machine Vulnerability Report

Sub - Installed Third-Party Applications Detailed
This report is a sub-report of 04 – Installed Third-Party Applications. This list all devices with a specific application or a specific application and specific application version installed.

Clickable Links: None Installed Third-Party Applications Detailed

Sub - Last Update Scan By OS
This is a sub-report of the software update dashboard. This allows you to see the last software update scan by workstation, server, or specific operating system.

  • Clickable Links: Computer Name

Last Update Scan By OS

Sub - Third-Party Updates Date Range
This is a sub-report of the software update dashboard. This report shows third-party updates and their compliance status for specific months or date ranges.

  • Clickable Links: Title

Third-Party Updates Date Range

Sub - All Updates By Device
This is a sub-report of the software update dashboard. This allows you to see how many third-party updates are missing for each device.

  • Clickable Links: Computer Name

Third-Party Updates By Device

Sub - All Updates Date Range
This is a sub-report of the software update dashboard. This report shows updates and their compliance status for specific months or date ranges.

  • Clickable Links: Title

Third-Party Updates Date Range

Sub - All Updates By Device
This is a sub-report of the software update dashboard. This allows you to see how many updates are missing for each device.

  • Clickable Links: Computer Name

Third-Party Updates By Device