KACE Product Support

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



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

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).