Previous Topic: Origin and Trust LevelNext Topic: Reconciliation


Schema Changes for Origin and Trust Level

To store the origin and trust level information of the assets/users, the following schema changes have been made to asset tables:

Table Name

Column Name

Column Datatype

Column Null Option

Column Comment

inv_root_map

trustlevel

integer

not null

Defines the trust level for a component discovered on an asset/user.

Default: 5

inv_root_map

origin

nvarchar(64)

not null

Defines the origin information for a component discovered on an asset/user.

ca_agent

trustlevel

integer

not null

Defines the trust level of an asset/user.

Default: 5

ca_agent

origin

nvarchar(64)

not null

Defines the origin of an asset/user.

ca_discovered_hardware

external_host_key

nvarchar(64)

 

not null

Defines the key generated or passed by the Asset Collector.

ca_discovered_software

trustlevel

integer

 

Defines the trust level of discovered software of an asset/user.

Default: 5

ca_discovered_software

origin

nvarchar(64)

not null

Defines the origin of discovered software of an asset/user.