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.

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

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

Answered 06/30/2012 by: jverbosk
Red Belt

  • 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
  • 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?
  • 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
Please log in to comment

Answers

2

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

Answered 06/30/2012 by: jverbosk
Red Belt

  • Oh, and if you want to use the Break on Columns for the patch schedules, use this in that field:

    PATCH_SCHEDULE

    John
Please log in to comment

Please log in to comment
Answer this question or Comment on this question for clarity