K1000 Ticket rule for unassigned tickets left in the queue
Anyone have a current ticket rule for unassigned tickets left in the queue? I am looking for the email body to contain the ticket number, Issue. submitter, priority, and created date and time in this format: mm/dd/yy and hh:mm:ss in 12 hour format.
Also need this rule to kick off every 1 hour for tickets left unassigned for that period of time, email will need to go to the IT Director.
Any help would be greatly appreciated because I am not a SQL guy.
There are no answers at this time