Is there a CONTROL table within KACE? For holding times, for example?
Here is the intent: I want specific ticket rules to only run (successfully, at least) during business hours. In its current state, KACE cannot do this on its own so I have to write business hours within a query's where filter so it only succeeds at the specified time.
In each individual ticket rule / query, I (at this time) have to add in business hours:
and TIME(NOW())<'18:00:00' and TIME(NOW())>'05:00:00'
and DAYOFWEEK(NOW()) in (2,3,4,5,6)
This works fine for each ticket rule, however, I've created a maintenance nightmare. If our business hours were to ever change, then I would have to go through and update each ticket rule that has this time frame within the where filter.
Is there a way that I can just write the business hours, or this filter, into a data table and have the ticket call upon that data table for it to run only when those specifications are met? This way I only have to update that business hour table/data cell and it would take effect for all ticket rules, as opposed to having to go in and fix each individual ticket rule (which, in reality, can be changed via a statement writing to the HD_TICKET_RULE table that finds and changes those values.)
That all being said, the solution is to have a control table that is called upon. I was hoping such a table existed and I could just populate it and then call upon it. Another issue I can already see is the success of calling on such a table within a ticket rule.
Has anyone tried this?