SCCM – Security updates Compliance Overview report V2

Quick post about some of the changes I’ve made to the security updates compliance overview reports; So here’s some of the enhancement that the new reports will allow you

– can now sort the display by number of missing updates.

– add a column to get total of targeted updates (approved updates).

– Removed the Installed updates column.

1- create a report called  Security Updates Detail based on the following query

Report Sql Query 

*********************************************************

2- Create a report called Software Updates Compliance Status by Collection and configure the link to the report created in step 1

Report SQL Query

 

Advertisements

8 thoughts on “SCCM – Security updates Compliance Overview report V2

  1. Johnny

    I have SCCM 2012…will this be the same process for creating the report? Report Builder giving me all types of issues.

  2. Glyn

    is there a way to complete these using a range of collections? I have a CTE to return a list of CollIDs and want to report on all of these collIDs in one instance.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s