AssetTypeProperty Table

AssetTypeProperty defines extra custom properties for all assets.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for AssetTypeProperty table

Database Column

Details

AssetTypePropertyID

Type: integer. Key. Generated ID

A unique identifier for a property of an asset type.

PropertyName

Type: text (max 256 characters). Key

The name of the property.

AssetTypeID

Type: integer. Key. Nullable

Asset type with which this property is associated. Foreign key to the AssetType table.

HardwareClassName

Type: text (max 256 characters). Nullable

The WMI class name associated with this property. This field applies for hardware properties that are mapped to hardware inventory tables.

HardwarePropertyName

Type: text (max 256 characters)

The WMI property name associated with this property. This field applies for hardware properties that are mapped to hardware inventory tables.

CustomPropertyDisplayX MLID

Type: integer. Nullable

Foreign key to a record in the CustomPropertyDisplayXML table, describing how to show the property on a property dialog.