Return
-
Title
List of all machines that are currently in Reboot Snooze status from patching -
Description
This report is to list out all machines that are currently in "Reboot Snoozed" in the patching run. -
Resolution
NOTE: All SQL code provided as a courtesy by KACE to its customers. We make no promises as to workability or functionality under certain circumstances. In default situations under normal setup these work as designed. KACE does not support modification nor usage. We highly recommend you test all code no matter the source before using in a production environment. If you are cut and pasting the code, paste in to a text editor then copy back out to remove any hidden characters or markup.Here is the SQL query to use to find those machines:
SELECT DISTINCT NAME, IP, LAST_SYNC, UPTIME from MACHINE join KBSYS.KONDUCTOR_TASK KT on KT.KUID = MACHINE.KUID and KT.TYPE like 'kpatch%' and KT.PHASE ='reboot snoozed'
NOTE: To List out machines that are currently in different phase in patching mode, you can replace the word 'reboot snoozed' in the SQL query above with some of the common status of patching:
reboot pending
suspended
completed
%error%
The KT.PHASE part can also be removed altogether to get a glance of the patching status on All Devices. Do note that Reboot Pending and Reboot Snoozed are two separate statuses, difference being that Snoozed is when the end user snoozes the reboot for hours later.
If you would like additional help on customizing this report, contact Professional Services. -
Additional Information
This report is a copy from the built-in report "Devices Needing Reboot", which shows device with status: reboot pending.