[SOLVED] KACE K1000 - SQL Query Asset Values

Hi all,

i have a Asset called "Transponder" with these fields
  • Name as Text
  • Transponder as Single Select with values 123, 456, 789, 1010, 1123
  • Date as Date
  • Description as Text

So far so good.

Now I want to select the selectable values (123, 456, 789, 1010, 1123) via query, so i can select these in a ticket queue by custom field with single select.

For me I only have to change/add new transponder-ids in one table and not in the asset settings and in the queue setting.

Is that possible? I tried already with a lot of differnt SQL query, but didn't find the data i searched for.

Thanks in advance.



0 Comments   [ + ] Show comments

Answers (2)

Posted by: StepBaer 5 years ago
Senior White Belt

thanks for your answer - but I already tried this.
I will explain my problem a little more detailed.

This is the asset type, with the field "Transponder" and the highlighted data/values I want to select in a query

This is the result of


But this is only the already existing assets with the selected value, not all transponder values.

Maybe no it is more clarfied.



  • Yes, that helps. The data you are looking to query is in the ASSET_FIELD_DEFINITION table. If you query that table you'll find a row that shows your values in the FIELD_VALUES column where the FIELD_NAME is "Transponder". The problem with using that table is that when you use the service desk custom fields with the query syntax I believe it is looking for rows to be returned, but you would be returning one row with a set of comma delimited values. You can try a query like SELECT FIELD_VALUES from ASSET_FIELD_DEFINITION where FIELD_NAME = "Transponder" but I'm not sure if it will work.

    You could create another asset type called Transponders and use your transponder values as the names of those assets. If you need to track the data in the current Transponder asset type then it can reference the Transponders asset type, too. That way both the service desk and the Transponder asset type both reference the same data. When you need to add more transponders to the list you just create the new asset. - chucksteel 5 years ago
    • Hi, sorry for my late reply. Your answer helped me and I created a new asset called "Transponder Values". No I can select them by

      Thanks for your Support! :) - StepBaer 5 years ago
Posted by: chucksteel 5 years ago
Red Belt
You will need to look at the database in order to know the names of the table associated with your asset type. The data should be stored in ASSET_DATA_# where # is the ID of the Transponder asset type. I recommend setting up MySQL Workbench to look at the database. 

If the name of the transponder is the number, then the select statement should be (assuming the asset type ID is 10):

If the transponder number is only stored in the Transponder field then the select query will also need to pull from the appropriate ASSET_DATA table.

  • Please see my answer below :) - StepBaer 5 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


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