/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Help creating SQL query to display last time updates were installed.

11/07/2014 4505 views
Hi,

Most computers in my environment are automatically updated, however there is a set of users have a more sensitive environment that they know well and we allow them to control their updates. I would like to make a report that shows the last time an update was installed. Many of these machines are Macs and some are windows, is there a way to use Kace to pull information on the date the last update was installed and then output a report showing the computers that haven't updated in a given amount of time?

I have taken a look at the following page, but this is for macs and windows. I would also prefer using a KACE report rather than a script if at all possible.
http://www.itninja.com/question/report-showing-the-date-the-last-time-a-computer-had-patches-deployed

Thanks.
2 Comments   [ + ] Show comments

Comments

  • Are you still running a patching schedule on these machines to detect patches?
  • Yes they are all on a detect schedule.

Be the first to answer this question

 
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