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:
Please log in to answer
Posted by:
flip1001
7 years ago
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
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