/build/static/layout/Breadcrumb_cap_w.png

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

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.

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: flip1001 7 years ago
Black Belt
0

Top Answer

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

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