How do you map assets to a custom ticket field?
I thought I did this before but can't remember what I did. How do you map a custom a custom ticket field to individual assets?
Basically I set up all our buildings as assets. On the ticket layout field, I have custom field 1 and I want to insert those assets into the field, so when the user goes to fill out a ticket, they can choose their building. I wanted to do it this way instead of writing out each building's name. I swear I thought I had done with before but I can't remember how or what I did.
Thanks,
Basically I set up all our buildings as assets. On the ticket layout field, I have custom field 1 and I want to insert those assets into the field, so when the user goes to fill out a ticket, they can choose their building. I wanted to do it this way instead of writing out each building's name. I swear I thought I had done with before but I can't remember how or what I did.
Thanks,
1 Comment
[ + ] Show comment
Answers (1)
Please log in to answer
Posted by:
Hobbsy
9 years ago
There is a default example built into the queue, if you go to the queue and then customize fields and layouts and scroll down to the custom field section. Click the small blue question mark next to the heading, in there you will see the example:
query: select distinct(LOCATION) from USER
If you have the location fields pulled in from your AD, they will then be shown in the dropdown, otherwise you will need to use the solution as in the comments from tshupp
Comments:
-
FYI. With the new version of K1000 (7.0.121306) this query no longer works due to the reorganization of the Location asset. Use this instead: QUERY: SELECT ASSET.NAME FROM ASSET WHERE ASSET_TYPE_ID=1 ORDER BY ASSET.NAME ASC - DirtySoc 7 years ago
-
Which is kind of ironic as it is still the example displayed within the queue configuration. Nice testing Quest!! - Hobbsy 7 years ago
In the help desk queue, under the section called "Custom fields" define the desired field to be field type "single select" or "multiple select".
Set the select list of values as the query with the word "query:" written at the front so that the K1000 appliance knows to get the results. Replace X with the asset type ID you found in the first step.
e.g.
query:select ASSET.NAME FROM ASSET WHERE ASSET_TYPE_ID=X ORDER BY ASSET.NAME ASC
https://support.software.dell.com/k1000-systems-management-appliance/kb/114937 - tshupp 9 years ago