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

Comments

Please log in to comment

Answers

0

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.

 

Answered 05/05/2014 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity