BDNA Data Platform 5.4 July 2017 (SQL Server)
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 numeric 20 Host ID
DOMAIN nvarchar 512  √  null Domain
HOSTNAME nvarchar 2048  √  null Host Name
SERIALNUMBER nvarchar 512  √  null Serial Number
DISOVERED_OS_MANUFACURER nvarchar 512  √  null Discovered OS Manufacturer
DISOVERED_OS_NAME nvarchar 2048  √  null Discovered OS Name
DISOVERED_OS_VERSION nvarchar 512  √  null Discovered OS Version
DISOVERED_OS_PATCH_LEVEL nvarchar 512  √  null Discovered OS Patch Level
OS_INSTALLDATE datetime 16,3  √  null Operating system Install Date
OS_MANUFACTURER varchar 255  √  null Operating system Manufacturer
OS_NAME varchar 255  √  null Operating system Name
OS_MINOR_VERSION varchar 64  √  null Operating system Minor Version
OS_MAJOR_VERSION varchar 64  √  null Operating system Major Version
OS_SERVICE_PACK varchar 64  √  null Operating system Servie Pack
OS_EDITION varchar 255  √  null Operating system Edition
CAT_TAXONOMY_CATEGORY1 varchar 256  √  null Taxonomy Category 1
CAT_TAXONOMY_CATEGORY2 varchar 256  √  null Taxonomy Category 2
CAT_MANUFACTURER_ID numeric 20  √  null Catalog Manufacturer Id
CAT_SW_PRODUCT_ID numeric 20  √  null Catalog Product Id
CAT_SW_VERSION_ID numeric 20  √  null Catalog Version Id
CAT_SW_VERSION_GROUP_ID numeric 20  √  null Catalog Version Group Id
CAT_SW_EDITION_ID numeric 20  √  null Catalog Edition
CAT_TAXONOMY2012_ID numeric 20  √  null Catalog Taxonomy Id
CAT_SW_RELEASE_ID numeric 20  √  null Catalog Release 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

Confidential and Proprietary to BDNA