Creating a report
So I would like to create a report, that would tell me when a new version of for example Adobe Reader is downloaded? That way I can stay on-top of the updates. I know that we receive e-mails that tell us Kace updated patches available, but can they be more specific.
Please log in to answer
Posted by: chucksteel 4 years ago
Since some of our users are admins and can update software themselves I also created a report that uses the inventory. This report shows new versions of Adobe Flash Player, for instance:
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
You should be able to change the DISPLAY_NAME to Adobe Acrobat Reader.