How to tell if a machine isn't in a patch task
Hi,
Is there a way to tell if a machine isn't in a patch group? Like machine x was just recently added and isn't in a patch job?
Thanks,
mike
Answers (3)
If your machine patch labels are all named similarly, you could use the following report and just tweak the 'patch' target at the end. For point of reference, my machine patch labels use a naming convention like "patch (roaming - XPsp3)". I tested and verified this pulled up the three machines in my network without patching schedules.
SELECT M.NAME
FROM MACHINE M
WHERE M.NAME NOT IN
(SELECT M.NAME
FROM MACHINE M
JOIN MACHINE_LABEL_JT ML ON (ML.MACHINE_ID = M.ID)
JOIN LABEL L ON (L.ID = ML.LABEL_ID)
WHERE L.NAME rlike 'patch')
ORDER BY M.NAME
Hope that helps!
John
Try a report that checks for machines without a patch label applied.
