This report will list all the patches in each of the patch labels in the K1000 appliance.
Instructions for installing the report:
1. Go to Reporting -> Reports tab -> On the left drop downlist, choose "Add new SQL report"
2. Use the following information for each of the paremters:
A. Title: A Listing of all patches in each of the patch labels
B. Report Category: Patching
C. Description: This report will list out all the patches assigned to each patch labels.
D. SQL Select Statement:
SELECT L.NAME as LABEL_NAME,
PP.TITLE AS PATCH_TITLE FROM PATCHLINK_PATCH_LABEL_JT PPLJT
join LABEL L on L.ID = PPLJT.LABEL_ID
join KBSYS.PATCHLINK_PATCH PP on PP.UID = PPLJT.PATCHUID
order by PPLJT.LABEL_ID
E. For Break on Columns: LABEL_NAME
F. For XML Report Layout: select Auto-generate Layout
G. Press Save button to save report