ca_logical_asset_property

Allows for one logical asset to have many identifying attribute values.

Column Name Column Datatype Column Null Option Column Comment
mac_address nvarchar(64) not null MAC address. Identifying attribute. (e.g. MAC address found on hardware by discovery tool) Third part of the primary key.
dns_name nvarchar(100) not null Primary key unique identifier
logical_asset_uuid byte(16) not null Foreign key to the logical asset record which this property describes. First part of the primary key.
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.
exclude_registration integer with null Exclude Registration
delete_time integer with null Delete time

Product Name: Asset

Table Type: Table


Copyright © 2006 CA. All rights reserved.