/build/static/layout/Breadcrumb_cap_w.png
10/16/2014 3221 views
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:
0 Comments   [ + ] Show comments

Comments


All 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