/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Select Value link to Asset Type

06/03/2015 1069 views
Hi,

I need some help. I'm trying to use "Select value" (Servicedesk-Custom Fields). I want to put the value from the Asset Type Department and map to servicedesk "Department" field.
Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0
In order to use asset values in the service desk you need to create a query. 
Set the custom service desk field to Single Select
For the Select Values field use the following:
query:select ASSET.NAME FROM ASSET WHERE ASSET_TYPE_ID = 2 ORDER BY ASSET.NAME ASC
This will select the assets from the table where the asset_type_id is 2, that is the ID for the Department asset on my KBox.

The service desk field will be populated with the results of the query when you view a ticket and you can select the appropriate value from the list.
Answered 06/03/2015 by: chucksteel
Red Belt

  • Hi Chucksteel,

    Thanks for the query but when i put the query in the Servicedesk "Custom Fields" it shows my query.
    • Can you post a screenshot of the configuration?
      • This content is currently hidden from public view.
        Reason: Removed by member request For more information, visit our FAQ's.
      • now its working perfectly. Initially i did not put the word "query" that is the mistake. thanks a lot for your help.

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