Report to find machines missing Patch Schedule
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:
0 Comments
[ - ] Hide Comments
Answer this question
or Comment on this question for clarity
Answers
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.
Please log in to comment
-
Bingo. Thanks a million.
One small change and it worked great:
Where
PSMS.PATCHLINK_SCHEDULE_ID Is Null
Comments