BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_CONSOLE_USER - Console user 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
ID number 0  √  null Unique Console user ID
INVENTORY_ID number 18  √  null Inventory ID for this row
TASK_ID number 18  √  null Task ID for this row
OPERATINGSYSTEM_ID number 0  √  null Operating System ID for this console
HOST_ID varchar2 100  √  null Host ID for this console
TIMESTAMP date 7  √  null Timestamp
LASTCONSOLEUSE_TIME date 7  √  null Timestamp when console was used last time
NUM_CONSOLE_LOGONS float 126  √  null Number of logins for this console
DOMAIN nvarchar2 1024  √  null Domain the console belongs to
SYSTEM_CONSOLE_USER nvarchar2 500  √  null System console user
DOMAIN_USERNAME nvarchar2 500  √  null Domian User Name
TOTAL_USER_CONSOLE_MINS float 126  √  null Total time in minutes for the user on this console

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + HOST_ID + DOMAIN_USERNAME Primary key Asc/Asc/Asc/Asc PK_DISC_CONSOLE_USER These unique columns are also nullable
Confidential and Proprietary to BDNA