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

Comments

  • 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.
Please log in to comment

Answers

0
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.
Answered 05/05/2016 by: chucksteel
Red Belt

  • This was awesome just what I was looking for.
Please log in to comment
Answer this question or Comment on this question for clarity

Share