/build/static/layout/Breadcrumb_cap_w.png

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,

1 Comment   [ + ] Show comment
  • Find the asset type ID by going into Assets -> Asset Types and clicking on the asset type. The URL should end with ID=X

    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 8 years ago

Answers (1)

Posted by: Hobbsy 8 years ago
Red Belt
0
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 6 years ago
    • Which is kind of ironic as it is still the example displayed within the queue configuration. Nice testing Quest!! - Hobbsy 6 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ