The "ca_logical_asset links distinct asset source records to the single asset they may represent. There is a one-to-many relationship between the ca_logical_asset table and the ca_asset_source table. For example, if two different discovery tools have each discovered an asset and each created their own ca_asset_source record, there will be only one ca_logical_asset record created for the asset. The single logical asset record will then be referenced by the two asset source records that indicate where the asset entered the system. ca_logical_asset also supports the existence of multiple virtual logical assets that can be part of one physical asset. The logical asset allows for the tracking of these virtual assets
| Column Name | Column Datatype | Column Null Option | Column Comment |
| logical_asset_uuid | byte(16) | not null | Unique identifier for the logical asset. Primary key. |
| asset_uuid | byte(16) | with null | Foreign key to the ca_asset table for the physical asset which this logical asset represents. |
| host_name | nvarchar(255) | with null | Host name. Identifying attribute. (e.g. machine name found by UAM discovery) This is a logical asset attribute because the value could be different for different virtual sessions. |
| 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. |
| exclude_registration | integer | with null | Exclude Registration |
| delete_time | integer | with null | Delete Time |
| version_number | integer | with null | Version number for transaction integrity. |
Product Name: Asset
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| logical_asset_uuid | ca_asset_source | logical_asset_uuid |
| logical_asset_uuid | ca_disc_event | logical_asset_uuid |