/build/static/layout/Breadcrumb_cap_w.png

Software Question


Report MS Office Installs for versions older than 2013

11/15/2017 895 views
I have been asked for a K1000 report for computers within a particular label (smart label based on domain) that have an installation of MS Office older than version 2013.  I have been trying to modify various canned reports without luck... any SQL gurus out there willing to help out a greenhorn?  Looking for it to return computer name, username, IP, and Office version.

Thanks!
Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0
Here you go:
SELECT MACHINE.NAME AS SYSTEM_NAME, LAST_SYNC,
USER_LOGGED, IP,
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 '%Microsoft Office Professional%'
and substring_index(SOFTWARE.DISPLAY_VERSION, ",", 1) < 15
GROUP BY MACHINE.ID ORDER BY SYSTEM_NAME

Answered 11/16/2017 by: chucksteel
Red Belt

 
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