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

Community Chosen Answer

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

Answers

0
I have found an easy way to build custom reports.

First I look under "Software" and see what the software is called..

In my case, the software is/was called a couple of different titles..

They were:
Microsoft Skype For Business Entry 2016
Skype For Business 2016 - en-us
Skype For Business Basic 2016 - en-us
Skype For Business Basic 2016

I also need to exclude checking our servers so I limit the search to everything except the server label

2Lg100.png

When I have the search results that populate correctly,  I then click on the "Choose Action" drop down and select Create Report, and all of the SQL code gets entered for you automatically based on your search...

This has saved me lots of time on many occasions

Hope it helps someone else..

JT
Answered 02/21/2017 by: jct134
White Belt

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