Help creating SQL query to display last time updates were installed.
-
Drave
- How helpful is this to you?
- Average Rating 0
- 3218 views
- 11/07/2014
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
[ - ] Hide Comments
There are no answers at this time
Comments
-
-
chucksteel
-
-
3 years ago
-
-
Are you still running a patching schedule on these machines to detect patches?
-
-
Drave
-
-
3 years ago
-
-
Yes they are all on a detect schedule.
Please log in to comment