KACE Product Support Question
12/03/2014 2993 views
I have a question regarding the ticket escalation system. I want to make a report that mails every admin users (theres 4 of them including me) if a ticket has the status ''New'' for the past 5 days based on the creation date.
I create a ticket on the 3th of December. If the ticket has the status ''New'' till 8th of December, I want it to escalate and send a report to the admins.
If a ticket get created on the 4th, i want it to escalate on the 9th, and so on.
I can't find any SQL code on the web to work with and with the wizard is in my opinion not working the way i want.
So I hope anyone can point me in the right direction or even share there SQL, so I can work from that. :)
Thanks in advance,