I'd like something along the lines of:

System Name IP Address
Scheduled Task Status 
Schedule      Schedule Last Run Device Status Date Current Phase
 Windows Monthly Patching - Desktops 09/25/2015 08:00:32 2015-09-25 08:12:47 completed
Windows Pilot Group 09/10/2015 22:30:01 2015-09-11 07:43:40 completed
Detect ALL Missing Windows Patches 09/09/2015 10:30:40 2015-09-09 11:01:21 completed


Thanks in advance for any assistance.
1 Comment   [ + ] Show Comment

Comments

  • Here's what I have at the moment but it's not quite there.

    SELECT DISTINCT MACHINE.NAME as MACHINE_NAME
    , PATCHLINK_SCHEDULE.DESCRIPTION as SCHED_DESC
    , MAX(DEPLOY_STATUS_DT)
    , DEPLOY_STATUS
    FROM PATCHLINK_MACHINE_STATUS
    join PATCHLINK_SCHEDULE on PATCHLINK_SCHEDULE.ID = PATCHLINK_MACHINE_STATUS.SCHEDULE_ID
    left join MACHINE on MACHINE.ID = PATCHLINK_MACHINE_STATUS.MACHINE_ID
    GROUP BY PATCHLINK_MACHINE_STATUS.MACHINE_ID,PATCHLINK_MACHINE_STATUS.PATCHUID
    ORDER BY MACHINE_NAME, DEPLOY_STATUS_DT
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity
Nine Simple (but Critical) Tips for Effective Patch Management
This paper reviews nine simple tips that can make patch management simpler, more effective and less expensive.

Share