Table BDNA_PUBLISH.dbo.DISC_CONSOLE_USAGE_MAXGROUP
Has Discovered Console usage information

 Generated by
SchemaSpy
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 float 8 Inventory Id for this row
TASK_ID float 8 Task Id for this row
OPERATINGSYSTEM_ID float 8 Console Operating System Id
HOST_ID varchar 100 Console Host id
TOP_CONSOLE_USER varchar 500 Top users userid for this Console
SECURITY_LOG_START_DATE varchar 1024  √  null Security log start date
TOTAL_CONSOLE_TIME varchar 1024  √  null Total Console time in seconds
TOTAL_CONSOLE_USERS varchar 1024  √  null Total number of Console users
TOTAL_SECURITY_LOGTIME varchar 1024  √  null Total Security log time in seconds

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
INVENTORY_ID + TASK_ID + HOST_ID + TOP_CONSOLE_USER Primary key Asc/Asc/Asc/Asc PK_DISC_CONSOLE_USAGE_MAXGROUP