BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_OS_CAT_MAP - Operating 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
OPERATINGSYSTEM_ID numeric 20 Operating System ID for the opearting sytem
INVENTORY_ID numeric 20 Inventory ID for this row
TASK_ID numeric 20 Task ID for this row
CAT_MANUFACTURER_ID numeric 20  √  null Manufactuer ID from Catalog
CAT_SW_PRODUCT_ID numeric 20  √  null Software product ID from Catalog
CAT_SW_VERSION_ID numeric 20  √  null Software version ID from Catalog
CAT_SW_EDITION_ID numeric 20  √  null Software edition ID from Catalog
CAT_SW_RELEASE_ID numeric 20  √  null Software release ID from Catalog
CAT_TAXONOMY2012_ID numeric 20  √  null Software taxonomy ID from Catalog
CAT_CPE_URI_ID numeric 20  √  null CPE URI Id
DATASRC nvarchar 50  √  null Data Source for this row (e.g., SCCM, ADDM)
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_SW_PRODUCT_ID + CAT_SW_VERSION_ID + CAT_SW_EDITION_ID + CAT_SW_RELEASE_ID + CAT_TAXONOMY2012_ID Performance Asc/Asc/Asc/Asc/Asc/Asc DISC_OS_CAT_MAP_IDS_IDX
INVENTORY_ID + CAT_SW_RELEASE_ID Performance Asc/Asc REP_IDX__dta_index_DISC_OS_CAT_MAP_8_1141579105__K2_K8
Confidential and Proprietary to BDNA