I need some help creating a report that will show me machines that are missing a Patch Schedule. I'm probably just overlooking something simple. All I need is:  Machine name, Machine IP, Patch Schedule = None.

Thanks,

Dave
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
This query might work for you:
SELECT MACHINE.NAME, MACHINE.IP, PSMS.PATCHLINK_SCHEDULE_ID
FROM MACHINE
LEFT JOIN PATCHLINK_SCHEDULE_MACHINE_STATUS PSMS on PSMS.MACHINE_ID = MACHINE.ID
WHERE PSMS.PATCHLINK_SCHEDULE_ID = null

I'm not positive if it will work because we use a smart label to assign a default patching schedule to every machine so I don't have any machines that aren't applied to a patching schedule in my database.

Answered 09/22/2014 by: chucksteel
Red Belt

  • Bingo. Thanks a million.

    One small change and it worked great:
    Where
    PSMS.PATCHLINK_SCHEDULE_ID Is Null
Please log in to comment
Answer this question or Comment on this question for clarity