/build/static/layout/Breadcrumb_cap_w.png

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


0 Comments   [ + ] Show comments

Answers (1)

Posted by: RD94 4 years ago
Senior Yellow Belt
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

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