How do I run a report on various versions of adobe pro?
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
Answers (1)
Please log in to answer
Posted by:
chucksteel
11 years ago
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
Comments:
-
I ran the query, looks good! Thanks much for the help! - mgomez 11 years ago
