I'm new to KACE (we're running version 6.0) and want to create a report that lists computers that are missing a specific software title.  How can I do this?


Thanks

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

2

SELECT NAME AS 'Machine Name' FROM MACHINE
WHERE NAME NOT IN (SELECT M.NAME FROM MACHINE M JOIN MACHINE_SOFTWARE_JT MSJ ON (MSJ.MACHINE_ID = M.ID)
JOIN SOFTWARE S ON (S.ID = MSJ.SOFTWARE_ID) WHERE S.DISPLAY_NAME like '%Software Title%')
ORDER BY NAME


All you have to do is change the software title (bolded).


Answered 03/04/2015 by: fbilotta
Senior White Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share