/build/static/layout/Breadcrumb_cap_w.png

stop Escalation e-mail after hours

I am trying to stop escalation e-mails after hours, specially on weekends. I have been doing some reading in the forums and pretty much everything I've read said I can't do that with the built in rules and that I would have to create my own rules but most of these were a couple of years old..... Has there any new developments been done regarding this or does anyone know if this can currently be done on 6.3?

Thanks

0 Comments   [ + ] Show comments

Answers (2)

Posted by: Hobbsy 8 years ago
Red Belt
0
The 6.3 version of the K1000 introduces working time logic for each queue that you have. you are able to set working days of the week, the hours you will work on those days and also the holidays that you are not working.

This version also introduces priority based SLA's so you can set a resolution time for each priority, which uses the working time to calculate targets and also has escalation options which you are also able to configure to use the same working time calculations, so no alerting out of hours. 

Comments:
  • Working hours and holidays are set globally, not per queue. Just wanted to clarify that. - chucksteel 8 years ago
  • I do already have working hours setup but continue receiving escalation e-mails on weekends which is why I posted the question here.
    I am not using SLA's but I am using escalation time witin the priority values in queue customization.

    For instance I have for priority value of "Top Priority" an escalation time of 2 hours, "High" 4 hours, "Medium" 2 days .... and I seem to get an escalation e-mail following that schedule which is getting annoying during a weekend as we get flooded with e-mails from tickets opened on Thursday and Friday that are still open. - raul102801 8 years ago
    • If you are using escalations only then there is no way of disabling these out of hours. - Hobbsy 8 years ago
      • is there any way to take advantage of the pre-defined schedule and still have escalation e-mails? for instance, if I was to use SLAs, would that ignore the escalation times being used within the priority? - raul102801 8 years ago
Posted by: chucksteel 8 years ago
Red Belt
0
One outside of the box solution would be to create a rule that modifies the HD_PRIORITY table to set the ESCALATION_MINUTES column to 0 for all priorities. You could set this rule to run at the close of business. 
UPDATE HD_PRIORITY SET ESCALATION_MINUTES=0 WHERE HD_QUEUE_ID = 1
This would disable all of the escalation timers on queue 1.

You would need rules that set the values back at the open of business.
UPDATE HD_PRIORITY SET ESCALATION_MINUTES=60 WHERE HD_QUEUE_ID=1 and NAME="High"
I believe you would need a rule for each priority.

You could also look at deleting rows from the HD_EMAIL_EVENT table to disable emailing on escalation events. You would then need to insert rows to enable the emails.

Comments:
  • Thanks Chucksteel I do like the idea of changing the HD_Priority table and set the ESCALATION_MINUTES to 0 after hours and turn it back on in the morning however, after several attempts I haven't been able to get it working. I am SQL challenged however I am willing to try things and figure it out but so far no luck.... could you give me some additional pointers in the right direction? - raul102801 8 years ago
    • You need to do this using custom ticket rules. In the service desk module, create a new SQL ticket rule that runs at daily at 5:00pm (or whenever your close of business is). You can actually put the statement above into the "Select" statement of the new rule and KACE should execute it at run time. I would recommend checking the "Email results" box and having the results of the query emailed to you. - chucksteel 8 years ago

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