I'm new with Kace, so I'm probably missing somthing simple, but...

I'm trying to configure the following.  I have groups in AD for each patch group, organized by day, hour, and week of the month.  For example,  Patch_3RD_Fri_8PM.  I populate the group with the servers on that patch schedule

I created the parent label called Patch_3RD_Fri_8PM.   I have an LDAP machine filter that i associated with the parent label and which returns the proper group members.  

I created a patch schedule and configured for 8PM every day.   At this point, the label is dynamically created and the server is patched every day.

Now, here is where the issue is.   I have created a SQL query that uses the label and it verifies its FRI and its the 3rd week of the month.  The query returns the correct server list in MySql workbench.

Is it possible to create a smart label with the SQL query and associate the ldap filter AND the smart label so they are both evaluated for the patch schedule?



0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



So you have a Machine LDAP label for machines that will get patched the 3rd Friday?

You then created a patch schedule to run at that time, and associated that LDAP machine label to it?

I guess I'm lost on where the SQL query comes in and verifies the 3rd Friday? You should be able to use the CRON schedule under "run custom" using something like this "0 0 20 ? * FRI#3 *" (without quotes). That still needs to be tested, but it should run every 3rd Friday at 8.

Answered 05/20/2013 by: dugullett
Red Belt

Please log in to comment