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
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
9 years ago
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.
Comments:
-
Bingo. Thanks a million.
One small change and it worked great:
Where
PSMS.PATCHLINK_SCHEDULE_ID Is Null - dteetz 9 years ago
