/build/static/layout/Breadcrumb_cap_w.png

Report to show devices that DON'T have a software title installed?

Hey KACE Peeps!

Scratching my head a bit on this one. 

Can anyone advise me how to construct a report (or SQL) that would allow me to display devices that don't have a specific software title installed? I have a report that I created that shows me what machines have the software installed, but I'm struggling with how to get a report that shows me which machines still need the software installed. 

i.e. Here are a list of machines that do not have SoftwareA in their inventory list. 

Any help is greatly appreciated!!

0 Comments   [ + ] Show comments

Answers (3)

Answer Summary:
Posted by: kenwhite 6 years ago
Senior White Belt
0

I typically use the advanced search on the devices page and search something like the following:

Software Titles     does not contain    acrobat

This returns a list of machines that do not have any software with a title containing "acrobat."

I can probably use a similar logic in the reports if I need to, but these ad-hoc device queries usually do the trick.

Posted by: kenwhite 6 years ago
Senior White Belt
0
Or, in a "Device" report, use a filter with similar criteria.
Posted by: akmagnum 6 years ago
Red Belt
0

Top Answer

This report shows the list of all computers that DO NOT have

"adobe acrobat" installed on them.

You can replace "adobe acrobat " with  the software you want.

SELECT MACHINE.NAME AS SYSTEM_NAME  FROM MACHINE  WHERE (((not exists  (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME like '%adobe acrobat%')) ))  ORDER BY SYSTEM_NAME


 
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