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.
Community Chosen Answer
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.
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