Fix Software Update/Deployment Compliance Percentages in Reports/Console
When looking at deployment compliance reports for Software Deployments, Software Updates, etc. The Percent Compliant is not accurate.
See the following twitter thread for details: https://twitter.com/dhedges01/status/958818004619247616
It is because sccm has 3 tables with reports and each "chart" has different source.
What is most pathetic, is that even if evaluationstate on client is 1, so app is installed, it still can have error number in ErrorCode field in WMI. This will by reported by client as an ERROR to the vAppDeploymentErrorAssetDetails. And main chart in Monitoring section, gets data from thsi view. Thats why even if app is installed, shows no issues in Software Center, it still can be "red" on chart.
But when You click to see details of the chart, You will notice that number of errors decreased to real numbers and machine that was previously in ERRORS, on the chart, is no longer in ERRORS on the "details" page You just opened. For example chart will show 300 errors, so the ratio for Your deployment will be 95%, but when You go deeper to the chart and click the chart to see detailed numbers, You will notice that there is only 50 errors and machine that was previously in errors, is now in success. It is because the detailed status is taken from different view, from the PROPER view that shows REAL data for deployment.
That's why deployment status on monitoring page, makes completely no sense as it is fake.
The other funny thing in ERROR view in SQL is that error view contains also success deployment with status 1 and ErrorCode 0. Why it is not removed ? No idea.
Sorry to bother you mate - But I just wanted to check if you have had any positive updates on this issue you posted?
We are having the same issue where the compliance percentages are dodgy and not updating correctly.... Please let me know!
percent compliant = (total - (required + unknown))/total * 100
should be: installed / (total - not required) * 100 based on deployment statistics.