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.
Community Chosen Answer
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.