K1000 Reporting Question
Guys
Im looking to build a report to show me the "Schedule Last Run" date/time for all machines within a certain patch schedule.
Does any one have any experience building a report in Kace like this?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
10 years ago
Here is a report which includes the last time the schedule ran for each machine in a specific schedule:
SELECT MACHINE.NAME, PATCHED, NOTPATCHED, DETECT_FAILURES, LAST_RUNFROM PATCHLINK_SCHEDULE_MACHINE_STATUSJOIN MACHINE on MACHINE.ID = PATCHLINK_SCHEDULE_MACHINE_STATUS.MACHINE_IDWHERE PATCHLINK_SCHEDULE_ID = 3ORDER BY MACHINE.NAME
Note that the patch schedule ID for this report is 3, you will need to change that to match the schedule ID for your patching schedule.
