Tables
Constraints
Columns
BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_MISSING_HOSTS - Information about hosts that were not normalized
Related columns
Constraints
Comments
Legend
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
INVENTORY_ID
numeric
20
Inventory ID for this row
TASK_ID
numeric
20
Task ID for this row
HOST_ID
numeric
20
Host ID that is not normalized
AD_SITE
nvarchar
2048
√
null
AD_SITE for the host ID
USER_DOMAIN
nvarchar
2048
√
null
USER_DOMAIN for the host ID
USER_NAME
nvarchar
2048
√
null
USER_NAME for the host ID
NAME
nvarchar
2048
√
null
NAME of the host ID
DOMAIN
nvarchar
2048
√
null
DOMAIN for the host ID
ACTIVE
nvarchar
2048
√
null
Is the host ID active? (e.g., 1=yes, 0=no)
OBSOLETE
nvarchar
2048
√
null
Is the host ID OBSOLETE? (e.g., 1=yes, 0=no)
REASON
nvarchar
2048
Reason why this host is not normalized
Analyzed at Thu Jul 20 12:14 PDT 2017
Confidential and Proprietary to BDNA