/build/static/layout/Breadcrumb_cap_w.png

Miscellaneous Question


I need help creating a Device / Patching Scheduled Task Status report

09/25/2015 1327 views
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

Be the first to answer this question

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ