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
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.