/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


I need a report for Version 10x, that lists failed Patches

02/16/2020 600 views

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

0 Comments   [ + ] Show comments

Comments


All 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

Answered 02/19/2020 by: RD94
Senior Yellow Belt

 
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