/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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:
Cancel
0 Comments   [ - ] Hide Comments

Comments

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

Answer Chosen by the Author


Answers

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

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

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

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

Please log in to comment