I'd like to automatically assign a helpdesk ticket to a specific technician based on submitter email address.  Running the latest version of K1000.

Something like:

If submitter name = xxxxxx@xxxxx.com
Then
Assign ticket to specific technician.

I'm not a SQL guy but understand logic - seems like this should be pretty straight forward to setup in K1000 but not sure where to start.


Any help or suggestions appreciated!

3 Comments   [ + ] Show Comments

Comments

  • Are we to assume the @xxxx.com would be different for each tech that would get assigned the ticket?
  • How many xxxx.com are you supporting and how many techs as there a couple of ways that you could sort this with ticket rules
  • I want all tickets generated from staff located in our Munich office to be assigned to a specific tech. Thinking I would have a Munich label and add the 12-15 Munich staff to the label. Then the rule would check the label, and if its a Munich person, then assign to Munich tech.

    Hope this helps!
Please log in to comment

Answers

2
You can create a set of custom rules, or if you are an SQL guru probably just the one rule, but what you are basically doing is checking if the Submitter ID is associated with a specific Label Id and if it is set the owner ID to the appropriate Tech.

In its basic form I achieved this with the following ticket rule:

Select Statement
SELECT HD_TICKET.OWNER_ID, HD_TICKET.ID, USER_LABEL_JT.LABEL_ID
  FROM ORG1.HD_TICKET HD_TICKET
       INNER JOIN ORG1.USER_LABEL_JT USER_LABEL_JT
          ON (HD_TICKET.SUBMITTER_ID = USER_LABEL_JT.USER_ID)
  WHERE USER_LABEL_JT.LABEL_ID = 165 and HD_TICKET.HD_STATUS_ID = 5
So you may need to add in more details for your ticket as this one only checks to make sure it has a status on New for this queue, but in the above, Is the number of the User Label i.e. U_All_Munich_Users

Update Statement
update HD_TICKET, HD_CATEGORY as T5
    set HD_TICKET.OWNER_ID = 14
  where (HD_TICKET.ID in (<TICKET_IDS>))
in the update Statement it sets the ticket to the Munich Tech ID

You may also like to set a hidden switch field so this rule only fires when it is new, to prevent reassignment by mistake in the middle of the ticket's lifecycle
Answered 08/06/2015 by: Hobbsy
Red Belt

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