BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_HOST_OS - Match Operating system information table

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
HOST_ID number 0  √  null Host ID
DOMAIN nvarchar2 256  √  null Domain
HOSTNAME nvarchar2 1024  √  null Host Name
SERIALNUMBER nvarchar2 256  √  null Serial Number
DISOVERED_OS_MANUFACURER nvarchar2 256  √  null Discovered OS Manufacturer
DISOVERED_OS_NAME nvarchar2 1024  √  null Discovered OS Name
DISOVERED_OS_VERSION nvarchar2 256  √  null Discovered OS Version
DISOVERED_OS_PATCH_LEVEL nvarchar2 256  √  null Discovered OS Patch Level
OS_INSTALLDATE date 7  √  null Operating system Install Date
OS_MANUFACTURER varchar2 255  √  null Operating system Manufacturer
OS_NAME varchar2 255  √  null Operating system Name
OS_MINOR_VERSION varchar2 64  √  null Operating system Minor Version
OS_MAJOR_VERSION varchar2 64  √  null Operating system Major Version
OS_SERVICE_PACK varchar2 64  √  null Operating system Servie Pack
OS_EDITION varchar2 255  √  null Operating system Edition
CAT_TAXONOMY_CATEGORY1 varchar2 256  √  null Taxonomy Category 1
CAT_TAXONOMY_CATEGORY2 varchar2 256  √  null Taxonomy Category 2
CAT_MANUFACTURER_ID number 18  √  null Catalog Manufacturer Id
CAT_SW_PRODUCT_ID number 18  √  null Catalog Product Id
CAT_SW_VERSION_ID number 18  √  null Catalog Version Id
CAT_SW_VERSION_GROUP_ID number 18  √  null Catalog Version Group Id
CAT_SW_EDITION_ID number 18  √  null Catalog Edition
CAT_TAXONOMY2012_ID number 18  √  null Catalog Taxonomy Id
CAT_SW_RELEASE_ID number 18  √  null Catalog Release Id
INVENTORY_ID number 18  √  null Inventory Id
TASK_ID number 18  √  null Task Id
DATASRC nvarchar2 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 + HOST_ID Primary key Asc/Asc/Asc PK_MATCH_HOST_OS These unique columns are also nullable
Confidential and Proprietary to BDNA