SCCM – Software Update Groups Compliance Dashboard Revisited, Part 2

In this second part, I will share with you some of the sub reports that I have created for the main SUG dashboard (Software Update Groups Compliance Dashboard Revisited). This will give you the ability to get the details for some of the tables in the dashboard and of course they can also be run independently, as they also bring a lot of useful information.

Let’s start with the first report, which is one of my preferred ones. It’s link to the Top Vulnerable Assets table and can be very useful as it gives you all the details about the health of a specific client as well as the level of compliance for Software Updates. The report contains 3 parameters, which are:

  • Computer Name
  • Vendor – List of vendor from the update catalog
  • Category – Update classification

and also contains multiple tables such as Operating System, CM Client/AD, System Info and Software updates information. Here are some screenshot of the reports:SysInfoDetailed_1


*** It may requires that you add some AD attributes (ManagedBy, DesktopProfile) to your CM system discovery as well as adding the service status to your client policy settings ***  

And now let’s have a look to the second one, which is link to the Assets Information table. Well this part is the only one in the Dashboard that contains the information for all clients, so not only the one with the agent. There are three filters available for this reports, which are:

  • Client – All, Unmanaged and Managed
  • Operating System – filter per OS
  • Collection – filter per Collection

and it contains a table with some information about clients, which can be useful to troubleshoot your client.


I will stop here for now, as you have the reports required to drill from the first two table of the Dashboard:SubReport_1So here’s the link to get these reports:

System health for a specific computer

System Health Overall


8 thoughts on “SCCM – Software Update Groups Compliance Dashboard Revisited, Part 2

  1. Syed

    An error has occurred during report processing. (rsProcessingAborted)
    Query execution failed for dataset ‘TableData’. (rsErrorExecutingCommand)
    Invalid column name ‘desktopProfile0’. Invalid column name ‘managedBy0’. Invalid column name ‘managedBy0’. Invalid column name ‘managedBy0’. Invalid column name ‘managedBy0’. Invalid column name ‘managedBy0’. Invalid column name ‘managedBy0’.

    • Simon Brouillard

      Well if any of these attributes have values in your AD, the column will not be created in the
      CM database, can you try to at least add a value for these attributes for a test computer account in your AD? Worst case, you can just comment all the lines in the select statement. Let me know if you need any assistance on this one.

  2. Syed

    Invalid column name ‘desktopProfile0’. If i remove the desktopnprofile0 from query it says textbox70 is mapped to that field.

    can u give me the name of the textbox70 ? or can we remove both managedby and desktopprofile0?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s