I’m trying to generate a report for computers that have specific software and also a specific service and that state of the service. Still new to SQl Queries I’m having a hard time.  Any help would be much appreciated. 

1 Comment   [ - ] Hide Comment


  • You should be able to look at the delivered Software reports to get a start.

    You can then join the MACHINE table to the NTSERVICE table via MACHINE_NTSERVICE_JT.

    If you have a tool like TOAD or MySQL Workbench (both free), you can more easily modify the queries produced from the KACE reporting wizard.
Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity