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.

 

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

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

Answered 04/15/2013 by: nshah
Red Belt

Please log in to comment

Answers

0

Version needs to be in quotes '7.0.170'

Answered 06/06/2014 by: gke565
Yellow Belt

Please log in to comment
0

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

Answered 04/16/2013 by: GeekSoldier
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity