/build/static/layout/Breadcrumb_cap_w.png

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

11/07/2014 4174 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.

There are no answers at this time