I want to add location to an open Service Desk report but I do not see that field as one I can choose.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1

You will need to add location in as a custom field to your ticket. Then you have the choice either make the field a single select dropdown, and then populate the field with the locations you wish to see, or alternatively set the field to lookup from the user table.


If you import locations in from AD with your users, then you can display those location values on a drop down


Try something like this...

query: select distinct(LOCATION) from USER

If you click the blue question mark next to the Custom fields heading all will be revealed 

Answered 04/17/2015 by: Hobbsy
Red Belt

  • thanks!! That was great info.
Please log in to comment
1
You can add the location from the user table to a service desk report by adding the location column from the user table. The only difficulty is knowing how the join to the user table was created for the submitter field. If you joined to the user table using
JOIN USER SUBMITTER on USER.ID = HD_TICKET.SUBMITTER_ID
then the submitter's location will be
SUBMITTER.LOCATION

Answered 04/20/2015 by: chucksteel
Red Belt

  • Thank you !! I was able to create the query!
Please log in to comment
Answer this question or Comment on this question for clarity