All Schedules that contain a Patch Label
Hello, how do I make a report that shows ALL Kace Patching Schedules that contain a specific Patching Label? I am trying to delete a patch label but there are hundreds of schedules that may contain the patching label.
Answers (2)
If you can find the ID for the label you need to delete, do this by going to Home>Label Management and then Labels
Hover over the name of the label you want to delete and the ID will appear in a box in the bottom left of your screen.
Take that ID and create a report using this SQL, putting the ID in where it is highlighted in yellow below and run the report.
SELECT PATCH_SCHEDULE.DESCRIPTION, PATCH_SCHEDULE_LABEL_JT.LABEL_ID
FROM PATCH_SCHEDULE
INNER JOIN PATCH_SCHEDULE_LABEL_JT ON PATCH_SCHEDULE.ID = PATCH_SCHEDULE_LABEL_JT.PATCH_SCHEDULE_ID
WHERE PATCH_SCHEDULE_LABEL_JT.LABEL_ID = 36;
You should then see all the patch schedules associated with, or using that label.
Comments:
-
Thanks for the response. I cant seem to get any results. I did find the ID number which is 335 but it comes back with nothing. I tried removing the ; and tried removing the space b/w the = and 335 as well. Are you getting results back? - lama01 8 months ago
