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.
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.