This is part 2 of a 6 part series where I talk through common issues I have seen that skew the numbers for software updates, or make it difficult to explain the results.
I started with getting my initial report SQL code from Kent Agerlund (MVP config Mgr) on As soon as I used this SQL Query in My SCCM Dashboards , I quickly saw that I could not use the value “% Compliance” on the Y axis in combination with my “Deployment” name.
Right now I am going in the console to Monitoring, Deployments, then for each Deployment and checking to see which machines are Compliant etc.
It also queries the Microsoft support life cycle site and checks for expired or expiring operating systems currently deployed which you will need to address.
The Deployed Expired/Expiring Operating Systems slicer also allows you to filter the OS to give you an indication of whats expiring by count.
A manager at a customer asked me if it would be possible to have a general percentage of Software Update Percent Compliance spread over all the Software deployment Management advertisements that are targeted to Pre-Production and Production.
To accomplish this written a SQL query to to this .