K1000 Report: Computers having particular software
List of computers which are having particular software like "Adobe Reader Version 11"
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
anonymous_102124
9 years ago
Resolution:
SELECT NAME AS 'Machine Name' FROM MACHINE
WHERE NAME IN (SELECT M.NAME FROM MACHINE M JOIN MACHINE_SOFTWARE_JT MSJ ON (MSJ.MACHINE_ID = M.ID)
JOIN SOFTWARE S ON (S.ID = MSJ.SOFTWARE_ID) WHERE S.DISPLAY_NAME like '%SYMANTEC%' AND PUBLISHER like '%SYMANTEC%')
ORDER BY NAME