Help creating SQL query to display last time updates were installed.
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.
There are no answers at this time