January 2021’s free Microsoft Endpoint Manager Configuration Manager (ConfigMgr/SCCM/MEMCM) giveaway is the Software Updates Dashboard. This report is available in both Power BI and SSRS formats.
Why do you need this report? Keep reading below!
How often are you asked for the compliancy rate of the previous month’s software updates (SU)? If you are like most ConfigMgr admins, then it’s ALWAYS! Who has time, though, to do a thorough review of the entire list of SU in the ConfigMgr console? This list displays 1,000+ SU! In order to save yourself some time, you need to write what might look like an odd filtering query that only shows you last month’s SU. Don’t forget – first you must turn on (un-hide) several columns (Not Required, Total, Unknown) that are normally hidden in order for the results to make sense.
Once this is done and you have the results of your query, you must then decide how you are going to present this information to management. Do you take multiple screenshots of the results (it never fits neatly all on one page) or do you copy and paste the results into an Excel spreadsheet, a Word doc, or an email?
Each time this information is requested, which could be daily, weekly or monthly, you need to spend a lot of time compiling and reviewing this data. Wouldn’t it be nice to have a ready-made report?
Solution: Software Updates Dashboard
The Software Updates Dashboard is designed to mimic the Software Update Compliance Status report that is found within the ConfigMgr console, but our report comes with many more features! Not only can you select any year or month, but you decide what update classifications are displayed and what vendor SU are shown.
In the Power BI report version, selecting the report filters changes the results in an instant! You can print the results from both Power BI Report Server (PBRS) and Power BI Desktop (PBD). PBD also allows you to export the results to a PDF.
One of the best parts about the SSRS dashboard 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, How to Set-up an Email Subscription in SSRS.
Software Updates Dashboard – Term Definitions
wdt_ID TERM DEFINITION 1
Total Number of Computers
Count of Computers With the SU Installed
Count of Computers That Require the SU
Count of Computers Where the SU Is Not Required or Is Not Applicable
Count of Computers Where the State of the SU Is Not Known
Compliancy Rate -In other words, (Installed + Not Required) * 100 / Total, gives you the percentage of computers that are compliant.
You can multi-select all of the prompt values, but there are defaults and the following are the defaults for this report.
Update Classification: Security Updates
Year and Month: The previous month, e.g. January 2021 will show December 2020’s software updates.
Enhansoft Reporting – Software Updates Dashboard
The Software Updates Dashboard is found within Enhansoft Reporting’s Dashboard category. This category provides you with detailed dashboards and reports about your ConfigMgr environment. Many of the dashboards and reports in this category are designed to allow a ConfigMgr Administrator to review the health and status of their ConfigMgr environment without having to access the console. You can even have these dashboards and reports emailed to administrators at scheduled times!
Would you find it useful to see a list of last month’s SU? Then get the Software Updates Dashboard 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 TechTalk@enhansoft.com.
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.