/build/static/layout/Breadcrumb_cap_w.png

Create report listing computers without a specific software title

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

Answers (2)

Posted by: jct134 7 years ago
Senior Purple Belt
2
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
Posted by: fbilotta 9 years ago
Senior White Belt
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).


 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ