/build/static/layout/Breadcrumb_cap_w.png

Discovering New Flash Versions

I find it difficult to keep up with the release schedule of Flash Player updates, but I can rely on the fact that some users on my campus will upgrade on a regular basis. The following report will detect versions of Flash Player that have been installed the previous day. I schedule this report to run in the morning so when there is a new version released I get notified quickly and can login to the Adobe distribution site to download the installers for deployment.

SELECT SOFTWARE.CREATED, SOFTWARE.DISPLAY_NAME, SOFTWARE.DISPLAY_VERSION, COUNT(MACHINE.ID) AS INSTALLS,
concat("https://k1000/adminui/software.php?ID=",SOFTWARE.ID) AS LINK
FROM ORG1.SOFTWARE
JOIN MACHINE_SOFTWARE_JT on SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
JOIN MACHINE on MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID
WHERE DISPLAY_NAME like "Adobe Flash Player%"
AND SOFTWARE.CREATED > DATE_SUB(NOW(), INTERVAL 1 DAY)
GROUP BY SOFTWARE.ID

I include a link to the software title so that I can quickly access it, be sure to adjust the URL to match your server name. If you would prefer to run this report weekly then adjust the INTERVAL 1 DAY to read 7 DAY. 

Posted 9 years ago 4282 views

Comments

This post is locked
 
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