The master asset table (in the case of hardware) stores a list of physical machines that can be found within the organization. The list of assets recorded in the master asset table is a list of distinct assets in the organization, whether the assets are running multiple virtual or logical assets or whether the asset has been discovered or identified from multiple sources. A supporting table named "ca_asset_type" specifies a list of valid asset types that can exist in the master asset table (i.e. Hardware or Software). Software assets are owned software licenses. There will be one record stored in the master asset table for every license that is purchased in an organization. License attributes and additional information are available in the software license and owned resource tables.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| asset_uuid | byte(16) | not null | Unique identifier to identify the asset. Primary key. |
| label | nvarchar(255) | with null | The "name" of the asset. Label might be populated with values from different attributes depending on what data is available. For example, Label could be Host Name in the case of UAM discovery or DNS Name in the case of NSM discovery. |
| asset_tag | nvarchar(64) | with null | Identifying attribute. (e.g. alternate identifier located on sticker placed on machine) |
| serial_number | nvarchar(64) | with null | Identifying attribute. (e.g. serial number found on hardware by discovery tool) |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Date the record was created. |
| last_update_user | nvarchar(64) | with null | User or process that last updated the record. |
| last_update_date | integer | with null | Date the record was last updated. |
| version_number | integer | with null | Version number for transaction integrity. |
| asset_type_id | integer | with null | Foreign key to the ca_asset_type table to indicate the asset type. |
| exclude_registration | integer | with null | Exclude Registration |
| delete_time | integer | with null | Delete time |
Product Name: Asset
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| asset_uuid | ca_software_license | asset_uuid |