I need a report for Version 10x, that lists failed Patches
We are looking for a SQL report, that would list failed patching attempts (Device vs Patches), so we can patch them manually OR re-run patch schedule.
Kind of like this guy:
https://www.itninja.com/question/k1000-patch-reporting-question-failed-patches-that-need-manual-intervention
But for version 10.x
Answers (1)
Probably not exactly what you're asking for, but this may get you started.
Keep in mind that if you want to use this in a Label, you can't use the aliases.
I'd encourage installing MySQL Workbench and playing with it to get what you want.
SELECT M.NAME AS SYSTEM_NAME,
SYSTEM_DESCRIPTION, M.IP, M.MAC,
M.ID AS TOPIC_ID
FROM MACHINE M
JOIN PATCH_MACHINE_STATUS MS ON (M.ID = MS.MACHINE_ID)
JOIN KBSYS.PATCH PA ON (PA.ID = MS.PATCH_ID)
WHERE
PA.SEVERITY = 'Critical'
AND
MS.DEPLOY_ATTEMPT_COUNT >= MS.MAX_DEPLOY_ATTEMPT
AND
MS.PATCH_INSTALLED = 0
AND
PA.IS_SUPERCEDED = 0
AND
MS.PATCH_APPLICABLE = 1
