Reporting 100% Systems WUA UpToDate Not Accurate

[abeauchamp]

I had a previous installed version.

I just did that I am going to wait for it to rebuild and then scan for the day. I will post an update tomorrow.

Thank you.

[Cubert]

make sure to delete the script to..

[SteveT]

Cubert,

On the Hotfix Issues tab, how long after a system starts patching correctly is the Error list cleared? I really don't care if a system has had errors 2 months ago, but is now patching normally...

Steve.

[SteveT]

Cubert,

Also just noticed systems that have the "Exclude MSP Contract" box checked are being scanned and reported as systems with patching errors. Once again, if a system is not under contract, I don't really need to be disturbed with a list of patching errors...

[Cubert]

We will have an update out shortly (next week or so) that will resolve several of these issues.

[abeauchamp]

I deleted the DB tables and also the scripts and I am still showing 100% uptodate.

[Cubert]

I deleted the DB tables and also the scripts and I am still showing 100% uptodate.

This gauge may or may not work for you until the next release.


The query that drives this gauge has issues running for some people and we are rewriting it.

Code: Select all

Create Temporary Table TComp(SELECT * FROM plugin_sw_patch_remedy_wua Where WUAVersion Not IN (Select Distinct max(WUAVersion) FROM plugin_sw_patch_remedy_wua GROUP BY OS) And RemedyAttempts < 3);Select round(100 - ((Select count(ComputerID) from TComp WHERE ComputerID IN (Select ComputerID FROM computers WHERE LastContact > date_add(now(),interval -5 minute) and ClientID IN (Select ClientID FROM `plugin_sw_patch_remedy_config` Where MasterSwitch = 1)))/(Select count(computerID) from computers where OS like '%windows%' and ClientID IN (Select ClientID FROM `plugin_sw_patch_remedy_config` Where MasterSwitch = 1))* 100))as Percentage;drop table TComp

This query should produce a number between 0 and 100 as the percentage of less then MAX version for each OS.

We will have a new update out shortly to resolve this.

[wdyoung]

That did the trick!!!

[abeauchamp]

Good afternoon,

I am still showing 100% up to date on my gauge even after updating to the latest version.

[stu_u2k]

I have installed this for the first time today as I l know I have at least one of out date WUA Agent, however the plugin seems to thing everything is up to date WUA wise, please see 6 JPEGs showing each tab's status...

Thanks

Stuart.