POST UPDATED HERE
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 ***