/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


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

07/09/2018 2024 views
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!!
Answer Summary:
0 Comments   [ + ] Show comments

Comments

  • This content is currently hidden from public view.
    Reason: Removed by member request For more information, visit our FAQ's.

Answer Chosen by the Author

0

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


Answered 07/13/2018 by: akmagnum
Red Belt

All Answers

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.

Answered 07/10/2018 by: kenwhite
Senior White Belt

0
Or, in a "Device" report, use a filter with similar criteria.
Answered 07/10/2018 by: kenwhite
Senior White Belt

 
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