What is the K1000 query to have a certain asset type show up in the configuration of your queue?
"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.
Answers (3)
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.
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
Thank you chucksteel! i copied that exact query and it worked perfectly. Changing my ID number of course. Thanks again :)