Page 2 of 3
Re: Reporting 100% Systems WUA UpToDate Not Accurate
Posted: Mon Jan 18, 2016 3:19 pm
by 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.
Re: Reporting 100% Systems WUA UpToDate Not Accurate
Posted: Mon Jan 18, 2016 6:25 pm
by Cubert
make sure to delete the script to..
Re: Reporting 100% Systems WUA UpToDate Not Accurate
Posted: Tue Jan 19, 2016 3:49 am
by 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.
Re: Reporting 100% Systems WUA UpToDate Not Accurate
Posted: Tue Jan 19, 2016 5:47 am
by 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...
Re: Reporting 100% Systems WUA UpToDate Not Accurate
Posted: Tue Jan 19, 2016 12:30 pm
by Cubert
We will have an update out shortly (next week or so) that will resolve several of these issues.
Re: Reporting 100% Systems WUA UpToDate Not Accurate
Posted: Thu Jan 21, 2016 2:28 pm
by abeauchamp
I deleted the DB tables and also the scripts and I am still showing 100% uptodate.
Re: Reporting 100% Systems WUA UpToDate Not Accurate
Posted: Thu Jan 21, 2016 2:40 pm
by Cubert
abeauchamp wrote: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.
Re: Reporting 100% Systems WUA UpToDate Not Accurate
Posted: Thu Jan 21, 2016 5:56 pm
by wdyoung
That did the trick!!!
Re: Reporting 100% Systems WUA UpToDate Not Accurate
Posted: Wed Feb 03, 2016 8:34 pm
by abeauchamp
Good afternoon,
I am still showing 100% up to date on my gauge even after updating to the latest version.
Re: Reporting 100% Systems WUA UpToDate Not Accurate
Posted: Wed Mar 09, 2016 4:13 pm
by 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.