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

Please log in to comment

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!
Please log in to comment
Answer this question or Comment on this question for clarity

Share