This report shows what patches are not currently in a label. This is helpful so that you know what patches might need to be identified by a label manually or by setting up new filter criteria.
To further help you this report identifies the vendor of the patch, the release date of the patch and if the patch has been superceded or not.
It is recommend that you put "Status" in your Break on Columns Field when creating the report.
select
CASE WHEN PPS.STATUS=0 THEN 'Active'
WHEN PPS.STATUS=1 THEN 'Inactive'
WHEN PPS.STATUS=4 THEN 'Disabled' END AS "Status",
PP.TITLE,
PP.VENDOR,
RELEASEDATE,
IF(PPSUPER.PATCHUID IS NULL,'','Superceded') AS "Superceded"
from (KBSYS.PATCHLINK_PATCH PP
LEFT JOIN KBSYS.PATCHLINK_PATCH_SUPERCEDES PPSUPER ON PPSUPER.SUPERCEDES_UID=PP.UID)
JOIN PATCHLINK_PATCH_STATUS PPS ON PPS.PATCHUID=PP.UID
LEFT JOIN PATCHLINK_PATCH_LABEL_JT PPLJ ON PPLJ.PATCHUID= PP.UID
WHERE PPLJ.PATCHUID IS NULL
ORDER BY PPS.STATUS ASC, PP.VENDOR ASC, "Superceded" ASC,RELEASEDATE DESC