How do I link an Asset to a ticket so that the ticket appears in the asset detail page and for reporting.
06/26/2017 1409 views
I have several asset types so that I can group them.
Under my Service Desk Queue, I have created several custom multiple select fields which link to those asset types. However, they don't seem to appear in the asset detail page showing that they are linked after I have selected multiple of them. I have tried the single select instead and still the same thing.
This is the SQL I'm using under the Custom Fields in Queue Customization where ID # is the asset type:
query:select ASSET.NAME FROM ASSET WHERE ASSET_TYPE_ID=5 ORDER BY ASSET.NAME ASC
The only thing that works is the predefined asset and devices single select field.
Also, in case that we need this for reporting, I would like to make sure that linking the multiple assets to the ticket will not have any adverse affects on any functionality of the k1000.