BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_HOST_SW_INSTANCE - Host-Software Instance information matched

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
DISC_SW_PROD_ID number 0  √  null Link to the software instance to the software installation using the unique identifier (MATCH_HOST_SW_PROD and MATCH_HOST_SW_PROD_DET)
INST_GRP number 0  √  null Use to group a set of attributes that belongs to the same instance
INST_KEY varchar2 255  √  null Atttribute name
INST_VAL nvarchar2 1024  √  null Attribute value
DISCOVERED_ID varchar2 255  √  null Unique discovered Id from Addremove/Exe/OS (MATCH_HOST_SW_PROD and MATCH_HOST_SW_PROD_DET)
HOST_ID number 0  √  null Host ID
INVENTORY_ID number 18  √  null Inventory Id
TASK_ID number 18  √  null Task Id
DATASRC varchar2 25  √  null Data Source

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + DISC_SW_PROD_ID + INST_GRP + INST_KEY + DATASRC Must be unique Asc/Asc/Asc/Asc/Asc/Asc MATCH_HOST_SW_INST_UNQ_IDX These unique columns are also nullable
Confidential and Proprietary to BDNA