Is there a report that shows all of the PCs that are not scheduled from each of my patch schedules?
If you go to the edit details of a patch schedule, I want to be able to run a report that will show me the Machine Name of each machine that has a status of Not Scheduled. I would like this to be seperated by each of my patch schedules. This will allow me to go back and run these patch schedules for the people that were missed.
Answers (3)
You could also use this variation to show any machines that did not complete their patching run successfully. This is what I would personally use.
John
_______________________________
SELECT S.DESCRIPTION as PATCH_SCHEDULE, M.NAME as MACHINE, K.PHASE as STATUS, P.LAST_RUN
FROM PATCHLINK_SCHEDULE_MACHINE_STATUS P
JOIN PATCHLINK_SCHEDULE S on (S.ID = P.PATCHLINK_SCHEDULE_ID)
JOIN KBSYS.KONDUCTOR_TASK K on (K.TYPE=S.KONDUCTOR_TASK_TYPE)
JOIN MACHINE M on (M.KUID = K.KUID and M.ID = P.MACHINE_ID)
WHERE K.PHASE not rlike 'completed|reboot pending'
ORDER BY S.DESCRIPTION, K.PHASE, M.NAME
Comments:
-
Also, you probably want to use the KACE Product Support topic with Dell KACE K1000 and/or K1000 Reporting tags so this will appear there. I only saw this post by chance because it was on the main ITNinja page.
John - jverbosk 12 years ago -
This is really close to what I am looking for, but it is only showing the PCs with a status of Suspended. What would I have to do to get it to show Not Scheduled as well? - badams 12 years ago
-
It sounds like you may only have machines with Completed, Reboot Pending and Not Scheduled status. Remove the WHERE line and see what you get. This line says to exclude Completed and Reboot Pending statuses, so it should list everything else.
John - jverbosk 12 years ago
See if this will do what you want.
John
_______________________________
SELECT S.DESCRIPTION as PATCH_SCHEDULE, M.NAME as MACHINE, K.PHASE as STATUS, P.LAST_RUN
FROM PATCHLINK_SCHEDULE_MACHINE_STATUS P
JOIN PATCHLINK_SCHEDULE S on (S.ID = P.PATCHLINK_SCHEDULE_ID)
JOIN KBSYS.KONDUCTOR_TASK K on (K.TYPE=S.KONDUCTOR_TASK_TYPE)
JOIN MACHINE M on (M.KUID = K.KUID and M.ID = P.MACHINE_ID)
WHERE K.PHASE = 'waiting to connect'
ORDER BY S.DESCRIPTION, M.NAME
Comments:
-
Oh, and if you want to use the Break on Columns for the patch schedules, use this in that field:
PATCH_SCHEDULE
John - jverbosk 12 years ago
