"query: select distinct(LOCATION) from USER"  I tried using something like this which is the example given and repalcing location and user with my categories, but it did not work.

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1

If you want the name of the asset displayed then you need to know the asset's type ID. The easiest way to find this is to view the Asset Types page using the adminui (go to /adminui instead of /admin). Open the asset type like you're going to make a change to it and the URL will now contain the asset type ID at the end of the URL, e.g. ID=12.

In the service desk configuration your query would be:

SELECT NAME FROM ASSET WHERE ASSET_TYPE_ID = 12

You would put the number for your asset type where I have the 12 in that statement.

Answered 04/10/2013 by: chucksteel
Red Belt

Please log in to comment

Answers

0

to give you an example, we pull location in the helpdesk queue and department

query: select * from location

query: select * from department

 

You might want to try

query: select (distinct LOCATION) from USER

 

Answered 04/09/2013 by: nshah
Red Belt

Please log in to comment
0

Thank you chucksteel! i copied that exact query and it worked perfectly.  Changing my ID number of course. Thanks again :)

Answered 04/10/2013 by: peactera
Orange Senior Belt

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