I need help creating a Device / Patching Scheduled Task Status report
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
Answers (0)
Please log in to answer
Be the first to answer this question
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 - rcallbeck 8 years ago