[SOLVED] KACE K1000 - SQL Query Asset Values
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.
Community Chosen Answer
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
SELECT * FROM ASSET_DATA_#
But this is only the already existing assets with the selected value, not all transponder values.
Maybe no it is more clarfied.