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

Comments

Please log in to comment

Answers

1
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.
Answered 10/08/2015 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share