BDNA Data Platform 5.4 July 2017 (Oracle)
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 number 0  √  null Unique host ID
USERLOGON nvarchar2 1024  √  null User name
USERDOMAIN nvarchar2 1024  √  null User Domain
DOMAIN_USERNAME nvarchar2 1024  √  null User Domain and User Name
INVENTORY_ID number 18  √  null Inventory ID for this row
TASK_ID number 18  √  null Task ID for this row
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)

Analyzed at Thu Jul 20 12:13 PDT 2017

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