ca_asset_source

Contains a list of assets which have been reported by a given product

Column Name Column Datatype Column Null Option Column Comment
asset_source_uuid byte(16) not null Asset source ID.
logical_asset_uuid byte(16) with null Unique identifier for the logical asset. Primary key.
source_location_uuid byte(16) with null Unique identifier for the source location database. Primary key.
subschema_id integer not null Unique identifier for the subschema. Primary key.
creation_user nvarchar(64) with null Creation User
creation_date integer with null Creation date
last_update_user nvarchar(64) with null Last update user
last_update_date integer with null Last update date.
version_number integer with null Version number.
exclude_registration integer with null Exclude Registration
delete_time integer with null Delete Time
exclude_reconciliation smallint with null Exclude Registration.

Product Name: Asset

Table Type: Table

Relationships:

Primary Key Related Table Related Column
asset_source_uuid ca_discovered_software asset_source_uuid
asset_source_uuid ca_discovered_hardware asset_source_uuid
asset_source_uuid ca_owned_resource asset_source_uuid


Copyright © 2006 CA. All rights reserved.