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.
Click Reporting | Select Action | Add New Report (SQL).
Enter your report Title, Category, and Description fields and add the following SQL:
Note set Break on Columns to Status .
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 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center