/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Report - Software 'A' version, but only if Software 'B' is installed?

01/17/2017 733 views
Hi all,

Struggling with a SQL report. 

I'm wanting to return the machine ID, and the software 'A' title, but only if software 'B' exists. 


This is the SQL query I'm using - but I don't know how to filter to only show if Software B exists. 
Select MACHINE.NAME as Computer_Name,SOFTWARE.DISPLAY_NAME as Application_Name,display_version,IP from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE) where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_NAME like '%Software Title A%' order by DISPLAY_NAME

Any help greatly appreciated! My SQL-foo is weak.
Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0
Create a smart label with:
Software title contains 'Software A'
  New Group> Software title contains 'Software B'
Then copy the SQL to a report and add/remove fields you want to see
Answered 01/17/2017 by: flip1001
Fifth Degree Brown Belt

  • Sending a digital beer your way - that did it! Great idea and it worked. Thanks!
 
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