Report for Software Title not at the current version.
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.
Community Chosen Answer
You sould use something like thiS. Just replace the software and version number.
S.DISPLAY_NAME AS SOFTWARE_NAME,
S.DISPLAY_VERSION AS VERSION,
M.`NAME` AS MACHINE_NAME,
M.USER_FULLNAME AS LAST_USER,
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