List of computers which are having particular software like "Adobe Reader Version 11"
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

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

Answered 07/01/2014 by: anand.30hiremath
Blue Belt

Please log in to comment
Answer this question or Comment on this question for clarity