/bundles/itninjaweb/img/Breadcrumb_cap_w.png
List of computers which are having particular software like "Adobe Reader Version 11"
Answer Summary:
Cancel
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

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