BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_MISSING_HOSTS - Information about hosts that were not normalized

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