BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_CONSOLE_USAGE_MAXGROUP - Console usage 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
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 Console Operating System ID
HOST_ID varchar2 100  √  null Console Host ID
TOP_CONSOLE_USER nvarchar2 500  √  null Top users userid for this Console
SECURITY_LOG_START_DATE nvarchar2 1024  √  null Security log start date
TOTAL_CONSOLE_TIME nvarchar2 1024  √  null Total Console time in seconds
TOTAL_CONSOLE_USERS nvarchar2 1024  √  null Total number of Console users
TOTAL_SECURITY_LOGTIME nvarchar2 1024  √  null Total Security log time in seconds

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
INVENTORY_ID + TASK_ID + TOP_CONSOLE_USER + HOST_ID Performance Asc/Asc/Asc/Asc DISC_CONSOLE_USAGE_MAXG_IDX
Confidential and Proprietary to BDNA