/build/static/layout/Breadcrumb_cap_w.png

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 8 years ago

Answers (1)

Posted by: chucksteel 8 years ago
Red Belt
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.

Comments:
  • This was awesome just what I was looking for. - anaccarato 8 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ