So first, it’s been a long time since my last post. So I hope it will be an interesting one for you guys… and yes, it is about custom software update report again.
In this blog post, I will share with you a Dashboard for Software Updates Group and it’s based on the ones created by Gary Simmons, which are just incredible. So for those who aren’t using it yet, here’s a link that I recommended to read first, as it explains in detail most of the feature include in this Dashboard; SUG Dashboard from Gary Simmons
First, let’s talk about the parameters, in this Dashboard I’ve change the parameters to match our needs, so for that I’ve create a filter on the software update group parameter to only show the SUG that contains compliance in the name (This is use as a template containing all the updates that are required in our company). Other fields like Company and Entity match our Folder Structure in SCCM and Scope is the collections that are within the second level folder SCCM. Here’s an example of what we use:
And finally the OS Type parameters allows to scope this report by OS Type, Servers, Workstations, etc. it the case that you have different OS in the Collection.
Ok, so in the first part of the Dashboard I’ve change the Asset table to include all devices and the ability to drill down to get the detailed information. Also, in this part I added 2 tables to first get the top 10 vulnerable systems and them the top 10 missing updates.
In the second part, I’ve added a custom Overall Systems Compliance part (again from a report from Gary Simmons) which contains all the OS Versions.
And lastly in the third part, I’ve added a chart to show the Compliance level per update severity, a chart about the updates scan status (% of success) and Errors details, a chart with the top 5 Windows Updates version and a table with the Software updates point status (last sync time, sync status).
here’s a link from where you can download this dashboard, in the case you are interested to try it;
And in the next part, I will publish all the sub reports that I’ve create to drill down and get all the details information.
Part 2: Software Update Groups Compliance Dashboard Revisited, Part 2
This looks great… I am trying to execute and getting this error:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘Top_Systems’. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Forgot to mention, but yeah this requires the AD managedby attribute to be added to your system discovery. We use this attribute as the Owner of the computer, so this is why.
Otherwise, you can edit the report and changed the query to match your needs.
Nice job
Great Job, How would I make this where I can choose a Collection of all my Servers and then a compliance software update group only and not company and others such?