/build/static/layout/Breadcrumb_cap_w.png

Report for Software Title not at the current version.

Hello Everyone,

I've got a manager that likes me to produce rollups of which machines are not at the current Java version. He also requests these for Adobe Reader, Adobe Air, Shockwave, and Adobe Flash player. I was wondering if anyone has some SQL they're using that could be easily modified to create a report for each title. I'd only want the machine name, IP address, last login user, and the current software title w/version included in the results. Thank you in advance for your contributions.

 


0 Comments   [ + ] Show comments

Answers (3)

Answer Summary:
Posted by: nshah 11 years ago
Red Belt
2

You sould use something like thiS. Just replace the software and version number. 

 

SELECT

S.DISPLAY_NAME AS SOFTWARE_NAME,

S.DISPLAY_VERSION AS VERSION,

M.`NAME` AS MACHINE_NAME,

M.USER_FULLNAME AS LAST_USER,

M.IP

FROM

SOFTWARE AS S

JOIN MACHINE_SOFTWARE_JT AS MSJ ON S.ID = MSJ.SOFTWARE_ID

LEFT JOIN MACHINE AS M ON MSJ.MACHINE_ID = M.ID

where S.DISPLAY_NAME like 'Adobe Reader%'

and S.DISPLAY_VERSION < 12

and not IS_PATCH

order by S.DISPLAY_NAME, S.DISPLAY_VERSION, M.NAME

Posted by: gke565 10 years ago
Senior Yellow Belt
0

Version needs to be in quotes '7.0.170'

Posted by: GeekSoldier 11 years ago
Red Belt
0

Broke on line 15. Ideas on how to get around this?

 
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