BDNA Data Platform 5.4 July 2017 (SQL Server)
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 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