How can I add Location to a Service Desk report?
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
Answers (2)
Please log in to answer
Posted by:
Hobbsy
9 years ago
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
Comments:
-
thanks!! That was great info. - Mbivona 9 years ago
Posted by:
chucksteel
9 years ago
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
Comments:
-
Thank you !! I was able to create the query! - Mbivona 9 years ago
