11. May 2018 · Write a comment · Categories: Microsoft, SCCM · Tags: , , , ,

I wasn’t getting what i needed from the built in SCCM SSRS Reports. Admins were asking for it to be made easier to understand how bad the number of outstanding updates were for the systems they have ownership of. For example, how many of the outstanding updates are 0-30 days old or 60+ days old.

The attached report “should” clearly indicate how old the outstanding updates are. The parameters can be adjusted to fit your business SLA model for deploying updates.

The RDL also only contains one collection. Add your own collections to the report by modifying the COLLID parameter (you will need to know the Collection ID).

Default date parameters/columns are:-

0 – 30 Days Old

31 – 60 Days Old

61 Days and Older

There is also a column to show if the client requires a restart. Often pending restarts can affect new updates being installed.

*** Big thanks to Eswar Koneti @eskonr and Adam Gross @adamgrosstx for their collective SSRS Examples and SQL Ninja Skills ***


SCCM Report to group number of outstanding updates, for a collection, in 30 day intervals
5 (100%) 2 votes

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.