Can patch deployments be scheduled for second Tuesday plus a certain number of days
I need to find a way to automatically deploy patches 2 days after patch Tuesday but I can only find a way to schedule it for the same day every month and the 2nd Tuesday is not always followed by the 2nd Thursday. Is this something that is possible?
Answers (2)
Negative, KACE's CRON does not support that logic.
You might want to vote and comment here:
https://kace.uservoice.com/forums/82699-sma-k1000/suggestions/6297279-custom-cron-schedules
by default you cannot do this, but with a little bit of maths you can create a smart label to do so.
a week has 7 days (mon-sun or sun-sat depending on where you live)
the earliest date is the 8th (because the 1st of the month needs to be a tuesday too)
to be the latest one is the 14th (because the first and the 8th of the month are a wednesday and the 15th too)
add 2 to these dates and you have a time frame between the 10th and the 16th.
With these informations you can create a smart label (I used another smart label called M_SL_LAN which contains all systems in the same subnet of the KACE for that but you are free to use your own here)
It tests for the current day of the month and chooses all OVER 9 and BELOW 17, so you have 10-16 in it.
from MACHINE
JOIN MACHINE_LABEL_JT ML ON ML.MACHINE_ID=MACHINE.ID
JOIN LABEL L ON L.ID=ML.LABEL_ID
WHERE
L.NAME='M_SL_LAN'
and DAYOFMONTH(CURRENT_DATE)>9 and DAYOFMONTH(CURRENT_DATE)<17
With this info you simply run the deployment on thursdays to machines in this label.
If you run it on the 27th (today) the label is empty, on the 11th of the next month it is populated. (which would be the 2nd tuesday + 2 days as you need)
