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?

0 Comments   [ + ] Show Comments

Comments

  • This content is currently hidden from public view.
    Reason: Removed by member request
    For more information, visit our FAQ's.
Please log in to comment

Community Chosen Answer

1

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

wuauserv
Answered 05/27/2014 by: SMal.tmcc
Red Belt

  • 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
    • had to post new answer to include screen shot, see that
Please log in to comment

Answers

0

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

 

Answered 05/27/2014 by: SMal.tmcc
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity