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

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2

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

Answered 12/06/2012 by: jverbosk
Red Belt

Please log in to comment

Answers

1

Try a report that checks for machines without a patch label applied. 

Answered 12/05/2012 by: jdornan
Red Belt

Please log in to comment
0

you can look under security-patching for that machine

Answered 12/05/2012 by: SMal.tmcc
Red Belt

  • also your patch label should be listed under activities -labels
Please log in to comment
Answer this question or Comment on this question for clarity
Nine Simple (but Critical) Tips for Effective Patch Management
This paper reviews nine simple tips that can make patch management simpler, more effective and less expensive.

Share