The Five BEST ConfigMgr Reports

Did you know that Configuration Manager (ConfigMgr/MEMCM/SCCM) has over 500 built-in reports and dashboards? Yes, it is true! With so many to choose from and admins not having a lot of time to review them, I put together this list. Here are the five best ConfigMgr reports you need to check out!

1. Compliance 5 – Specific computer

This report tops the list because, for obvious performance and security reasons, it is really important to understand what software updates (SU) were applied or are going to be applied to a computer. This report shows you exactly that: what SUs were applied, which SUs are required and which SUs need to be installed by a deadline.

Folder Location

It can be found within the Software Updates – A Compliance folder.

Microsoft Description

This report returns the software update compliance data for a specified computer.

Five Best ConfigMgr Reports – Report #1 Sample Screenshot

Five Best ConfigMgr Reports - Report 1

What’s Great About This Report?

  • As was already pointed out, this report is great for knowing what SUs were applied to a computer, as well as what SUs need to be applied.
  • Where appropriate, SU installation deadlines are noted.
  • You can get more information about a particular SU by clicking on the handy URL.

2. Lifecycle 05A – Product lifecycle dashboard

This dashboard quickly shows you what Microsoft software products you need to replace NOW! You can also start pro-actively planning for product upgrades because the dashboard displays what needs to be replaced within the next 18-months.

In case you’re curious, the console report, along with this SSRS dashboard and its accompanying report set, was first released in the 1806 version of ConfigMgr current branch. Having the console report available as a SSRS dashboard enables you to create an email subscription to it, which you can’t do with the console version.

Folder Location

It can be found within the Asset Intelligence folder.

Microsoft Description

This report provides an overview of product lifecycle data in the hierarchy. The data is the same as what is displayed in the Product Lifecycle dashboard in the console.

Five Best ConfigMgr Reports – Report #2 Sample Screenshot

Five Best ConfigMgr Reports - Report 2

What’s Great About This Report?

  • Without having to go out and search the internet for the lifecycle dates for each product, you can see their status in one place!
  • It allows you to proactively determine what software needs to be replaced and when!
  • You can email this SSRS dashboard to your management team each month for them to review the status of your environment.

3. Count of all instances of software registered with Add or Remove Programs

This is the best and most reliable built-in ConfigMgr report for obtaining a good overall understanding about what software is installed within your ConfigMgr environment. Keep in mind, however, that software titles are not normalized in this report.

Folder Location

It can be found within the Software – Companies and Product folder.

Microsoft Description

Displays a summary of all instances of software installed and registered with Add or Remove Programs or Programs and Features on computers within the specified collection.

Five Best ConfigMgr Reports – Report #3 Sample Screenshot

Five Best ConfigMgr Reports - Report 3

What’s Great About This Report?

  • Reliability. When comparing all three of the main software inventory report types within ConfigMgr (Add/Remove Programs (ARP), Asset Intelligence (AI) and Software Inventory) this report provides the most reliable information.
  • If you need to perform a software audit then this is the report to look at! You should use this report whenever asked for a list of software within your environment.

4. Compliance 2 – Specific software update

If you haven’t guessed it by now, software and software update reports are among the best built-in ConfigMgr reports. This report, in particular, is very handy because you can use it to track the status of software updates (SUs). This requires, however, a bit of extra work on your part. First you need to export this report at regular intervals and then examine the results over time.

One of the columns in this report that you should pay close attention to is called, “Unknown.” The number in this column tells you how many computers haven’t returned details about the specified SU. When this number is above zero it means that it’s time to investigate which clients are not reporting details. In an ideal world the results for this column would always be zero.

Folder Location

It can be found within the Software Updates – A Compliance folder.

Microsoft Description

Displays the compliance data for a specified software update.

Five Best ConfigMgr Reports – Report #4 Sample Screenshot

Five Best ConfigMgr Reports - Report 4

What’s Great About This Report?

  • Without having to go out and purchase third-party reporting software, this built-in ConfigMgr report gives you a basic understanding about what’s happening with each SU within your environment.
  • It provides a good, overall understanding of the specified SU’s compliance status.

5. Hardware 01A – Summary of computers in a specific collection

If you need to find out basic details about computers within a specific collection, such as manufacturer, model, OS, etc., then this report is for you!

Folder Location

It is found within the Asset Intelligence folder.

Microsoft Description

Displays an Asset Intelligence summary view of computers in a collection you specify.

Five Best ConfigMgr Reports – Report #5 Sample Screenshot

Five Best ConfigMgr Reports - Report 5

What’s Great About This Report?

  • You can quickly see each computer’s details such as CPU, RAM, user name, OS, and serial number.
  • It is a simple one-stop-shop report which you can export to Excel if needed.

Five Best ConfigMgr Reports

Did I miss one that you think should be here? Let me know below in the comments section or via Twitter.

Are you looking for even more detailed reporting from ConfigMgr? Then, take a look at Enhansoft Reporting! Enhansoft Reporting extends the inventory details collected by ConfigMgr, such as computer monitors, local account and group details, shares and share permissions, etc., and then puts this information into over 150 clear and precise Power BI and SSRS reports. It doesn’t matter what version of ConfigMgr you are using, you can use all of Enhansoft Reporting’s reports! This new and exciting reporting package takes all of the hard work out of creating your own custom reports. Want to know more? Contact us today!

Leave a Comment

Share via
Copy link
Powered by Social Snap