BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_HOST_SW_INSTANCE - Software Info as Key-Value pairs for a particular Software Instance

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 numeric 20 Link to the software instance to the software installation using the unique identifier (MATCH_HOST_SW_PROD & MATCH_HOST_SW_PROD_DET)
INST_GRP numeric 20 Use to group a set of attributes that belongs to the same instance
INST_KEY varchar 255 Atttribute name
INST_VAL nvarchar 2048  √  null Attribute value
DISCOVERED_ID varchar 255  √  null Unique discovered Id from Addremove/Exe/OS (MATCH_HOST_SW_PROD & MATCH_HOST_SW_PROD_DET)
HOST_ID numeric 20  √  null Host ID
INVENTORY_ID numeric 20 Inventory Id
TASK_ID numeric 20 Task Id
DATASRC nvarchar 50  √  null Data Source

Analyzed at Thu Jul 20 12:14 PDT 2017

View Definition:
CREATE VIEW MATCH_HOST_SW_INSTANCE AS SELECT DISC_SW_PROD_ID,INST_GRP,INST_KEY,INST_VAL,DISCOVERED_ID, HOST_ID,INVENTORY_ID,TASK_ID,DATASRC FROM MATCH_HOST_SW_INSTANCE_237467998 UNION ALL SELECT DISC_SW_PROD_ID,INST_GRP,INST_KEY,INST_VAL,DISCOVERED_ID, HOST_ID,INVENTORY_ID,TASK_ID,DATASRC FROM MATCH_HOST_SW_INSTANCE_237470163 UNION ALL SELECT DISC_SW_PROD_ID,INST_GRP,INST_KEY,INST_VAL,DISCOVERED_ID, HOST_ID,INVENTORY_ID,TASK_ID,DATASRC FROM MATCH_HOST_SW_INSTANCE_9999
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA