BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_HOSTS_USERLOGON - User/Domain 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
HOST_ID numeric 20  √  null Host ID
USERLOGON nvarchar 2048  √  null User Login
USERDOMAIN nvarchar 2048  √  null User Domian
DOMAIN_USERNAME nvarchar 2048  √  null User Domian\Username
INVENTORY_ID numeric 20 Inventory Id
TASK_ID numeric 20 Task Id
DATASRC nvarchar 50  √  null Input Data Source

Analyzed at Thu Jul 20 12:14 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
TASK_ID + USERDOMAIN + USERLOGON Performance Asc/Asc/Asc DHU_LKPIDX
Confidential and Proprietary to BDNA