Contains information about discovered hardware devices on UAM during the hardware reconciliation process.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| dis_hw_uuid | byte(16) | not null | Primary key. UUID to uniquely identify the discovered asset within tables supporting discovery information. e.g. inventory information collected by UAM. |
| asset_source_uuid | byte(16) | with null | Foreign key to ca_asset_source table. Establishes the identification of a discovered asset . |
| system_id | nvarchar(255) | with null | System id |
| label | nvarchar(255) | not null | The name of the asset. |
| uri | nvarchar(255) | with null | URI |
| domain_uuid | byte(16) | not null | Represents the domain on which the asset was discovered. |
| host_name | nvarchar(255) | not null | Machine name. |
| host_uuid | char(36) | with null | Discovery specific attributes. |
| serial_number | nvarchar(64) | with null | System serial number. |
| vendor_name | nvarchar(255) | with null | Vendor name |
| asset_tag | nvarchar(64) | with null | Alternate identifier assigned to asset. |
| primary_network_address | nvarchar(255) | with null | Primary network address |
| primary_mac_address | nvarchar(64) | with null | MAC address. |
| class_id | integer | with null | Class field pointing to a classification category. The possible list of class values will be a flat list composed of a common set of values chosen from all the products (i.e. NSM, UAM, etc.). |
| usage_list | byte(32) | with null | List of agent products using this asset or available on this asset. |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| disc_serial_number | nvarchar(64) | with null | Disc serial number. |
| 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. |
| auto_rep_version | date | with null | Internal revision number used for replication and maintained by the DBMS. |
| directory_url | nvarchar(255) | with null | |
| discovery_changes_switch | smallint | with null | Flag indicating that changes to discovered data for this owned resource should be tracked. 0=False , 1=True |
| vuln_risk | integer | with null | Vulnerability risk |
| is_inventory_managed | integer1 | with null | Is inventory managed flag |
| asset_group_id | byte(16) | with null | Asset group id |
| vm_service_version_number | integer | with null | VM service version number |
| content_version_number | integer | with null | Content version number |
| last_inventory_report_date | integer | with null | Last inventory report date |
| is_created_as_asset | integer1 | with null | Is created as asset flag |
| primary_subnet_mask | nvarchar(16) | with null | Primary subnet mask |
Product Name: Asset
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| dis_hw_uuid | ca_coapi_agent_view_v1 ca_coapi_agent_view_nosrv_v1 ca_coapi_agent_view_nodomsrv_v1 ca_coapi_agent_view_nodom_v1 ca_coapi_agent_view_nosrv ca_coapi_agent_view_nodomsrv ca_coapi_agent_view_nodom usd_v_agents dts_dtasset_view ca_link_dis_hw_user |
dis_hw_uuid |
| dis_hw_uuid | ca_link_dis_hw | secondary_dis_hw_uuid |
| dis_hw_uuid | ca_engine | dis_hw_uuid |
| dis_hw_uuid | ca_discovered_hardware_network | dis_hw_uuid |
| dis_hw_uuid | ca_server | dis_hw_uuid |
| dis_hw_uuid | ca_n_tier | dis_hw_uuid |