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.