Patch Schedule Detect Results
Two part Question........ I have a "Detect Patches" Schedule. (Not newer than 30 days / Not older than 90 days) The run seems to work and completes at 100%. Under the "Show All" section. I see where it logs the results, for example:
My 1st question: What does the "patched 0" mean? Does it mean the server doesn't require any of the patches in the catalog for the schedule? Doesnt make sense to me because wouldnt the server show the patches as "installed"? We have a lot of the same OS servers so this doesnt make sense to me. We have a lot of "not patched" hits but also a lot of these "patched 0" marks and a few "patched X" hits.
|completed||Patched: 2, Not Patched: 2, Detect Failures: 0||11/01/2018 13:52:04|
|completed||Patched: 0, Not Patched: 1, Detect Failures: 0||11/01/2018 13:52:03|
2nd Question: How can you generate a report from this? I can copy and paste the output but would like to be able to generate reports on a schedule.
Please log in to answer
Posted by: chucksteel 2 years ago
Here's a report that shows this information based an a label being assigned to the machines:
SELECT MACHINE.ID, MACHINE.NAME,
FROM PATCHLINK_SCHEDULE_MACHINE_STATUS PSMS
JOIN MACHINE on MACHINE.ID = PSMS.MACHINE_ID
JOIN PATCHLINK_SCHEDULE P on P.ID = PSMS.PATCHLINK_SCHEDULE_ID
JOIN KBSYS.KONDUCTOR_TASK K ON P.KONDUCTOR_TASK_TYPE = K.TYPE and K.KUID = MACHINE.KUID
JOIN MACHINE_LABEL_JT on MACHINE_LABEL_JT.MACHINE_ID = MACHINE.ID
JOIN LABEL on LABEL.ID = MACHINE_LABEL_JT.LABEL_ID
LABEL.NAME = "No Patching"
ORDER BY MACHINE.NAME
In our case, we assign a label, "No Patching" to computers that are excluded from our standard patching schedules. You will need to adjust that label in the SQL above.