/build/static/layout/Breadcrumb_cap_w.png

Ticket Length alert

How can I get alerts or emails as a manager when a ticket has been open for X amount of days by agents?


2 Comments   [ + ] Show comments
  • What version of the SMA are you on?

    Do you want a report to be emailed to you or what would you like? - crodriguez 5 years ago
  • looks like it is 9.0.270
    and yes an email would be great for say 2 days and maybe 7 - tkroeker 5 years ago

Answers (1)

Posted by: Druis 5 years ago
Third Degree Green Belt
0

Try this: - 


Select 'email@mycompany.com' AS SENDMAIL,

S.NAME AS STATUS, 

T.ID AS ID, 

T.TITLE AS ISSUE,

U.FULL_NAME AS SUBMITTER, O.FULL_NAME AS OWNER,

T.CREATED AS CREATED, T.MODIFIED AS STALLED

FROM HD_TICKET T

JOIN HD_STATUS S ON (S.ID = T.HD_STATUS_ID)

JOIN USER U ON (U.ID = T.SUBMITTER_ID)

JOIN USER O ON (O.ID = T.OWNER_ID)

WHERE (S.NAME = 'Open' AND DATEDIFF(NOW(), T.MODIFIED) >= 2)


Create a custom ticket rule with the above script. Select 'Email each recipient in query results' and put the SENDMAIL column in the field marked  'Column containing email addresses'.  Set your frequency to run hourly.

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