/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


SQL Report for Adobe Acrobat and Adobe Reader

10/16/2014 3710 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
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ