/build/static/layout/Breadcrumb_cap_w.png

Ticket rule to rotate new tickets between 4 owners on first opening

Hey Everyone,


I initally have started by using a coin flip round robin for any new tickets between two technicians for service desk tickets.  Since we have added two new technicians, this definitely doesn't work as well.  Adding two different technicians has proven that the coin flip actually has made it that one of the technicians has received around 9/10 of the tickets.  I was wondering what others were doing in the form of doing a round robin type approach in spreading out tickets evenly when they get assigned in a ticket rule.  This is currently my update statement:

update HD_TICKET, USER as T5

    set HD_TICKET.OWNER_ID = T5.ID

 where T5.USER_NAME = (select U2.USER_NAME from USER as U2 where USER_NAME in ('owner1','owner2','owner3','owner4') order by rand() limit 1)

 and 

        (HD_TICKET.ID in (<TICKET_IDS>))


I know that this is rather simple, but I'm hoping that I could come to a simple conclusion on what I could be able to do to get this going quickly.  Thank you for all of your help!




0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 3 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