Devices not in a Patch deployement Schedule
So when you are looking at a device under patching detect/deploy status. If it is part of a deployment schedule it will say "Patches will be Deployed from these Patch Schedules". If it is not part of a patching schedule it will say "Patch Deployement is not enabled for this device".
Where I can find that in the database so that I can run a report against all devices to quickly find out which devices are not part of a deployment schedule?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
IgorAngelini
2 years ago
Who knew that those set theory classes in collage would come in handy? Try (PS. You can use this as a smart label if you want):
SELECT DISTINCT MACHINE.ID AS TOPIC_ID,
MACHINE.NAME AS SYSTEM_NAME
FROM (
MACHINE
LEFT OUTER JOIN PATCH_SCHEDULE_MACHINE_PATCH_JT MPJ
ON MPJ.MACHINE_ID = MACHINE.ID
)
WHERE MPJ.MACHINE_ID IS NULL
