/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: chucksteel 9 years ago
Red Belt
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.

 

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ