/build/static/layout/Breadcrumb_cap_w.png
04/04/2018 515 views
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

Comments



Community Chosen Answer

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".

Answered 04/05/2018 by: chucksteel
Red Belt

All Answers

0
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))
Answered 04/24/2018 by: JasonEgg
Red Belt