Is it possible to access the Asset field

Is it possible to access the asset field in a custom rule 

I cant find the field listed anywhere. 

0 Comments   [ + ] Show comments

Answers (3)

Posted by: chucksteel 1 year ago
Red Belt

Yes, the asset tables are accessible. I recommend using a tool like MySQL Workbench and connecting to the database to view the tables.

ASSET - this is the main table for assets and includes the asset names and data common to all asset types.

ASSET_DATA_x - where x is the asset type ID for each type of asset. Most of the data about an asset is stored here. The column names are generated dynamically and will be in the form FIELD_y where y is the ID of the field.

ASSET_FIELD_DEFINITION - contains the field definitions for the assets, handy to use as a reference to figure out the column names in the ASSET_DATA_x tables.

Posted by: prince0052 1 year ago
Senior Yellow Belt

Asset relationships represent non-hierarchical relationships between assets due to replacements, upgrades, or other circumstances. Relationships appear in the Primary Assets and Related Assets related lists on asset records.

  • Thanks. That link between a HD ticket and the asset only works if the data is entered into the one and only asset field. We have other fields (e.g. Vehicle Asset) which provides a selection list based on that asset type. However when you go to the vehicle record there is no related HD ticket. If I enter the vehicle record into the Asset field that comes with Service Desk it creates that link. The reason we are using a unique asset field for Vehicles is that we want it only to list the vehicles (not the 25000+ assets). There is no way to build a rule to select only the vehicle asset type in the Asset record (If there was I would use the default Asset field) - kiwiblue 1 year ago
    • Are you using the asset field for another purpose for those tickets? If not, then you could create a rule that sets the asset field to the asset selected in your vehicle field. - chucksteel 1 year ago
      • Thanks Chucksteel. I have managed to do that but the Fleet number field (which is using the Vehicle asset name) when I use a rule to put it into the Asset field it seems to try and look for the unique asset id. E.g. if the Fleet number is 157 but the unique asset id for that record is 25045. When I get the custom rule to put the value (157) into the Asset field it seems to go and find the asset with a unique Asset id of 157. - kiwiblue 1 year ago
      • Your rule needs to be something like this:
        WHERE ID in (<TICKET_IDS>)

        The x in CUSTOM_FIELD_VALUEx needs to match the value of the custom field column in the database, these are zero indexed, so custom field 1 is CUSTOM_FIELD_VALUE0.

        The y in ASSET_TYPE_ID = y is the ID of the asset type for your vehicle assets. - chucksteel 1 year ago
Posted by: prince0052 1 year ago
Senior Yellow Belt

These ways include bookmarking assetsaccessing assets from the History node, tagging ... In the asset's Create view, in the Name field, enter a name for the asset. ... The following characters are not allowed: single quote ('), double quote (") 

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