This report is to list out all machines that are currently in "Reboot Snoozed" in the patching run.
Here is the SQL query to use to find those machines:
SELECT DISTINCT M.NAME, M.IP, M.USER_NAME, KT.PHASE AS PATCHING_PHASE
FROM KBSYS.KONDUCTOR_TASK KT
LEFT JOIN ORG1.MACHINE M ON M.KUID =KT.KUID
WHERE KT.TYPE LIKE 'patch%' and KT.PHASE like 'reboot snoozed'
ORDER BY M.NAME
Attached is the exported report (RebootSnoozedReport.zip) that can be imported into the K1000 appliance.
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 (Signature Download Failed)