Table BDNA_PUBLISH.dbo.DISC_CONSOLE_USER
Has Discovered Console user 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
ID float 8 Unique Console user Id
INVENTORY_ID float 8 Inventory Id for this row
TASK_ID float 8 Task Id for this row
OPERATINGSYSTEM_ID float 8 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
TOTAL_USER_CONSOLE_MINS float 8 Total time in minutes for the user on this console

Analyzed at Thu Oct 04 14:29 PDT 2012

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