Alerting when tickets are not assigned
When tickets are created by users and not assigned for long time say 40-60 mins, help-desk admin/group
should receive an email that tickets are not assigned
Please log in to answer
Posted by: Soloman007 4 years ago
You can use a Custom Ticket Rule to do this. Just use the wizard and add your logic, for example:
This will create your select statement:
If Ticket Owner is Null and Status = New (this will seek those tickets)
Then simply use the built in tool to customize your email.
Add this to the beginning of your select SQL statement:
select "firstname.lastname@example.org,email@example.com" as ADMINS (this creates the group that you'll add as the receipients in the email section) Just add ADMINS to "Column containing email address:" and it will send to those addresses you added to the select statement.
You will also have to add a time INTERVAL using the created date such as:
WHERE T.CREATED < SUBDATE(NOW(), INTERVAL 35 MINUTE)
then set the ticket rule to run every 15 min. This should get you to the 40-60 min time frame on the first email, and another email every 15 min, there after until it's assigned.
Hope this helps!