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.
1 Comment
[ + ] Show comment
-
Maybe I answered my own question. Create a report with labels for specific patches release within x number of days then schedule the report. or is there an easier way. - anaccarato 7 years ago
Answers (1)
Please log in to answer
Posted by:
chucksteel
7 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
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
You should be able to change the DISPLAY_NAME to Adobe Acrobat Reader.
Comments:
-
This was awesome just what I was looking for. - anaccarato 7 years ago
