Excessive count of computers in WUA versions tab

Support and question forum for Patch Remedy 4 WUA plugin for LabTech. This plugin was retired on 06/01/2022. All new Patch Remedy 5 is now the current plugin. This forum is for retaining the old posts for Patch Remedy 4.
User avatar
Cubert
Posts: 2468
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

Re: Excessive count of computers in WUA versions tab

Post by Cubert »

Run the following in SQL and post for me here.
SELECT * FROM plugin_sw_patch_remedy_maxWUA

jmaxwell
Posts: 42
Joined: Wed Apr 25, 2018 7:14 pm
6

Re: Excessive count of computers in WUA versions tab

Post by jmaxwell »

Ran the sql command and here are the results.
sqlmaxwua1.PNG
sqlmaxwua1.PNG (39.32 KiB) Viewed 7773 times
sqlmaxwua2.PNG
sqlmaxwua2.PNG (43.9 KiB) Viewed 7773 times

User avatar
Cubert
Posts: 2468
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

Re: Excessive count of computers in WUA versions tab

Post by Cubert »

ok that looks good except for the "I" entry at top of list. So lets drop that entry and any entry in WUA table that is making the entry into the MAXWUA table

Code: Select all

DELETE FROM plugins_sw_patch_remedy_maxWUA WHERE WUAVersion like '%I%'; DELETE FROM plugins_sw_patch_remedy_WUA WHERE WUAVersion like '%I%';

User avatar
Cubert
Posts: 2468
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

Re: Excessive count of computers in WUA versions tab

Post by Cubert »

Afterwards reopen plugin to refresh view, do both columns now show?

jmaxwell
Posts: 42
Joined: Wed Apr 25, 2018 7:14 pm
6

Re: Excessive count of computers in WUA versions tab

Post by jmaxwell »

That worked as far as showing the versions in the top window. That is correct.
However, we are still showing some spaces in the OS column(Windows 7 Professional x64 as in screen shot above, and misspellings as in line 866 in screen shot above)
It is still showing correct , up to date versions in the bottom section on machines. I know there are couple other threads on this issue and latest was it was being looked into. Wasn't sure if newest update .35 was supposed to resolve this or if it's still in progress.

Post Reply

Return to “Patch Remedy for LabTech (Patch Remedy 4) Retired”