Ticket rule to change the owner of the ticket to the "submitter"
In an effort to create a change management ticket routing i am trying to create a rule that based on the ticket status changes the owner of the ticket to the "submitter". I have looked in the wizard but there is no variable option to change the owner value to.Does anyone know the KACE sql id for the "submitter"?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
9 years ago
The update statement would be:
UPDATE HD_TICKET SET OWNER_ID = SUBMITTER_ID WHERE TICKET_ID in (<TICKET_IDS>)
I highly recommend setting up a tool like MySQL Workbench to look at the K1000 database if you will be creating ticket rules. It simplifies the process greatly if you can see the tables.
