Tables
Constraints
Columns
BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_CONSOLE_USER - Console user information discovered
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
ID
numeric
20
Unique Console user ID
INVENTORY_ID
numeric
20
Inventory ID for this row
TASK_ID
numeric
20
Task ID for this row
OPERATINGSYSTEM_ID
numeric
20
Operating System ID for this console
HOST_ID
varchar
100
Host ID for this console
TIMESTAMP
datetime
16,3
√
null
Timestamp
LASTCONSOLEUSE_TIME
datetime
16,3
√
null
Timestamp when console was used last time
NUM_CONSOLE_LOGONS
float
8
Number of logins for this console
DOMAIN
varchar
1024
√
null
Domain the console belongs to
SYSTEM_CONSOLE_USER
varchar
500
System console user
DOMAIN_USERNAME
varchar
500
Domian User Name
TOTAL_USER_CONSOLE_MINS
float
8
Total time in minutes for the user on this console
Analyzed at Thu Jul 20 12:14 PDT 2017
Confidential and Proprietary to BDNA