Software Update Compliance in SCCM with System information

Sometimes you need all the data in one place…

🚨🚨 IMPORTANT NOTICE🚨🚨

🦄 We moved to our brand new blog at MEM.Zone 🦄

🚨🚨 IMPORTANT NOTICE🚨🚨

Report release history

I hate software update reports but a customer wanted a lot more data than any reports we had. My limited SQL skillset was a real pain here.

I struggled with the ‘Pending Restart Reason’ until I read in some obscure forum that the value is in fact a bit-mask. The bit-mask is then used to get all the available states for a machine.

Why oh why is the documentation for these features so poorly maintained?

Notes
For this report you will need a string parser. I’ve included the code below to create that custom function.

Import the SSRS Report

• Download the report file

## Software update compliance report
SU Compliance by Computer Classification and Severity

• Start Internet Explorer on and navigate to http://YOUR_REPORT_SERVER_FQDN/Reports
• Choose a path and upload the previously downloaded report files
• Replace the DataSource in the reports
• Create the ufn_csv_String_Parser function using the SQL query below. Don’t forget to replace the {Your_Site_Code} with your site code!

Notes
The default exclusions are for antivirus definitions. Selecting ‘ShowInstalledUpdates’ wi
This report was created with SQL 2014 Reporting Services, you might need to remove some report elements if you use an older version.

SQL Helper Function

String parser helper function

Report Query

For reference only, since the report includes this query.

Software update compliance query

Report Preview

Computer and Compliance status — Part 1

Computer and Compliance status — Part 2