Report - patch reboot info, what is the variable?
I would like to add a field for patch reboot info (none, recommended, or required). I was wondering if someone could tell me what the PP.*** variable is for that?
My report is similar to the one here:
Select M.NAME as MACHINE_NAME,
PP.TITLE AS PATCH_NAME,
PP.IMPACTID AS IMPACT,
CASE WHEN MS.STATUS='PATCHED' THEN 'Installed'
WHEN MS.STATUS='NOTPATCHED' THEN 'Not Installed'
END AS 'PATCHED STATUS'
FROM PATCHLINK_MACHINE_STATUS MS
JOIN MACHINE M ON M.ID = MS.MACHINE_ID
JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID
JOIN PATCHLINK_PATCH_STATUS PPS ON PPS.PATCHUID = PP.UID
AND PP.IMPACTID = ('Critical')
AND PPS.STATUS = 0 /* 0=active patches */
order by MACHINE_NAME, PP.TITLE