SQL Report for Adobe Acrobat and Adobe Reader
Hi all, I'm trying to create a report that is gonna give me all the station that as Adobe Reader and Adobe Acrobat installed at the same time. If possible I wanted the report to only listed the name and version of Adobe Reader so I can uninstall them.
Here is the code I got so far:
SELECT
(SELECT group_concat(distinct MACHINE.NAME ORDER BY MACHINE.NAME separator '\n')
FROM MACHINE INNER JOIN MACHINE_SOFTWARE_JT MSJT ON MACHINE.ID = MSJT.MACHINE_ID WHERE MSJT.SOFTWARE_ID = SOFTWARE.ID) as MACHINE_NAME, DISPLAY_NAME, DISPLAY_VERSION
FROM SOFTWARE
WHERE (DISPLAY_NAME like '%Adobe Reader%') AND (DISPLAY_NAME like '%Adobe Acrobat%')
ORDER BY MACHINE_NAME, DISPLAY_NAME
Here is the code I got so far:
SELECT
(SELECT group_concat(distinct MACHINE.NAME ORDER BY MACHINE.NAME separator '\n')
FROM MACHINE INNER JOIN MACHINE_SOFTWARE_JT MSJT ON MACHINE.ID = MSJT.MACHINE_ID WHERE MSJT.SOFTWARE_ID = SOFTWARE.ID) as MACHINE_NAME, DISPLAY_NAME, DISPLAY_VERSION
FROM SOFTWARE
WHERE (DISPLAY_NAME like '%Adobe Reader%') AND (DISPLAY_NAME like '%Adobe Acrobat%')
ORDER BY MACHINE_NAME, DISPLAY_NAME
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
