Server Name + Software Name and Version
Anyone have an updated SQL query that will search for servers with a specific software title installed, then generate a report that shows the server name, software name and version?
1 Comment
[ + ] Show comment
Answers (1)
Please log in to answer
Posted by:
lama01
3 years ago
You would think this would be a common report but of course not. The wizard kind of works, not cleanly.
SELECT MACHINE.NAME AS SYSTEM_NAME, MACHINE.IP, OS_NAME FROM MACHINE WHERE ((( exists (select 1 from CATALOG.SAM_CATALOG JOIN SAM_MACHINE_JT on CATALOG.SAM_CATALOG.ID = SAM_MACHINE_JT.SAM_CATALOG_ID where MACHINE.ID = SAM_MACHINE_JT.MACHINE_ID and CATALOG.SAM_CATALOG.NAME like '%JAVA SE%')) )) ORDER BY SYSTEM_NAME - lama01 4 years ago