/build/static/layout/Breadcrumb_cap_w.png

Report to find clients not within a patching schedule?

Can anyone share a method to locate (whether with a report, or a smartlabel, or other means) clients within K1000 that are NOT in a Detect or a Deploy schedule? 

As far as I can tell, Reports will only key on states of a client's patching schedules, not if they are not in one at all.

0 Comments   [ + ] Show comments

Answers (2)

Posted by: chucksteel 5 years ago
Red Belt
1
My approach to this was to create all of my patching schedules with labels that end in the word "Patching", e.g. "Lab Patching", "Test Patching", "Picky Department Patching", etc. I then created a smart label called "Patch Production" that applies to any machines where label names does not end in "Patching". This allows us to define a default patching schedule for our production environment and machines automatically fall into that schedule unless we specify another schedule. 

If you don't want to have machines default to a schedule, then you could call your label something like "No Patch Schedule" and leave it at that. Just make sure your smart label doesn't end in the word "Patching".

Posted by: JasonEgg 5 years ago
Red Belt
1
Here is a query that will work to create a smart label for devices that are not part of an enabled patch schedule. So it includes devices on no patch schedules and those that only are on patch schedules that are disabled.
select ID as 'TOPIC_ID'
from MACHINE
where ID not in
  (select M.ID
  from MACHINE M
    join MACHINE_LABEL_JT MLJT on MLJT.MACHINE_ID = M.ID
    join PATCHLINK_SCHEDULE_LABEL_JT SLJT on SLJT.LABEL_ID = MLJT.LABEL_ID
    join PATCHLINK_SCHEDULE PS on SLJT.PATCHLINK_SCHEDULE_ID = PS.ID
    join IM_CRON on PS.IM_CRON_ID = IM_CRON.ID
  where IM_CRON.ENABLED = 1
    and PS.PATCH_ACTION in (1,2,3))

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ