Custom report to determine PCs with Windows Updates service disabled
Hi,
I'm trying to build a custom report query to list Kace Client computers that have the Windows Update service (wuauserv) set to disabled. Has anybody come up with one yet?
Answers (2)
that is pretty easy, go under reports and use the wizard, and choose "computer services" for the report topic, fill in the other fields. On the field to display page choose computernames. on the filter page create 2 filters service name = wuauserv and startup type = service_disabled
Comments:
-
Please forgive me for being new to this if I'm doing something wrong...
Under Topic, I do not have "computer services". I have one listed as "Computer" so I selected that.
Under Filters, I have a bunch of items, but I do not have one named "service name" to select.
Is it possible that you're describing a different version? We have a K1000 v5.4.76849 - boberic 10 years ago-
had to post new answer to include screen shot, see that - SMal.tmcc 10 years ago
may be I have version 5.5 running
here is the sql dump from the wizard for you
SELECT (SELECT GROUP_CONCAT(MACHINE.NAME ORDER BY MACHINE.NAME SEPARATOR '
') FROM MACHINE INNER JOIN MACHINE_NTSERVICE_JT MNTSJT ON MACHINE.ID = MNTSJT.MACHINE_ID WHERE MNTSJT.NTSERVICE_ID = NTSERVICE.ID) AS COMPUTER_NAMES FROM NTSERVICE left join (select @limitct :=0) T on 1=1 WHERE ((NTSERVICE.STARTUP_TYPE = 'service_disabled') AND (NTSERVICE.NAME = 'wuauserv')) ORDER BY COMPUTER_NAMES
