/build/static/layout/Breadcrumb_cap_w.png

Software Question


How do I run a report on various versions of adobe pro?

10/29/2013 3050 views

I've been asked to run a report that will tell how many have Adobe Pro installed.  However, dell kace doesn't group "Adobe Pro" into one software title, it has one for each version (and sub version it seems).  I need to be able to just run a report on any machine that has adobe pro, regardles of version installed.  Thanks.

0 Comments   [ + ] Show comments

Comments


All Answers

1

This gets messy because Adobe isn't very consistent with their naming conventions. Here's a SQL query that should work, however:

 SELECT MACHINE.NAME AS SYSTEM_NAME, 
USER_LOGGED, 
GROUP_CONCAT(DISTINCT SOFTWARE.DISPLAY_NAME SEPARATOR '\n') AS SOFTWARE_DISPLAY_NAME_GROUPED ,
GROUP_CONCAT(DISTINCT SOFTWARE.DISPLAY_VERSION SEPARATOR '\n') AS SOFTWARE_DISPLAY_VERSION_GROUPED
FROM MACHINE  
LEFT JOIN MACHINE_SOFTWARE_JT ON (MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID) 
LEFT JOIN SOFTWARE ON (SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID) 
WHERE (SOFTWARE.DISPLAY_NAME like '%Acrobat%Pro%')  
GROUP BY MACHINE.ID ORDER BY SYSTEM_NAME

 

Answered 10/30/2013 by: chucksteel
Red Belt

  • I ran the query, looks good! Thanks much for the help!

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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