BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_CS_CAT_MAP - Computer system to Catalog Mappping information discovered

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
COMPUTERSYSTEM_ID numeric 20 Computer System ID for this computer
INVENTORY_ID numeric 20 Inventory ID for this row
TASK_ID numeric 20 Task ID for this row
CAT_MANUFACTURER_ID numeric 20  √  null Manufacturer ID from the catalog
CAT_HW_PRODUCT_ID numeric 20  √  null Hardware Product ID from the catalog
CAT_HW_MODEL_ID numeric 20  √  null Hardware model ID from the catalog
CAT_HW_PROFILE_ID numeric 20  √  null
CAT_HW_MODEL_PROFILE_ID numeric 20  √  null Hardware profile ID from the catalog
CAT_TAXONOMY2012_ID numeric 20  √  null Taxonomy ID from the catalog
CAT_CPE_URI_ID numeric 20  √  null CPE URI Id
PHYSICALHOST numeric 20  √  null Physical Host
PHYSICALHOST_ID numeric 20  √  null Physical Host Id
DATASRC nvarchar 50  √  null Data Source for this row (e.g., SCCM, ADDM)
VIRTUAL numeric 20  √  null Is this hardware virtual?
REASONS nvarchar 2048  √  null Exceptions column for this row

Analyzed at Thu Jul 20 12:14 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
CAT_MANUFACTURER_ID + CAT_HW_PRODUCT_ID + CAT_HW_MODEL_ID + CAT_HW_MODEL_PROFILE_ID + CAT_TAXONOMY2012_ID Performance Asc/Asc/Asc/Asc/Asc DISC_CS_CAT_MAP_IDS_IDX
INVENTORY_ID Performance Asc REP_IDX__dta_index_DISC_CS_CAT_MAP_8_981578535__K2_5
INVENTORY_ID + CAT_HW_MODEL_ID Performance Asc/Asc REP_IDX__dta_index_DISC_CS_CAT_MAP_8_981578535__K2_K6
Confidential and Proprietary to BDNA