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
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
You can do this with the wizard also
byYVAI.jpeg

Z2Sqcw.jpeg

28my34.jpeg
AvAGqq.jpeg

Zrwg3I.jpeg

5ynti9.jpeg
Answered 10/16/2014 by: SMal.tmcc
Red Belt

  • I also forgot, under the software section, check uninstall command also and you will get that info
Please log in to comment
Answer this question or Comment on this question for clarity