Table sem5.dbo.V_ENFORCER_CLIENT_LOG
Query client activities for Enforcers

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
USN bigint 8
DOMAIN_ID char 32
SITE_ID char 32
TIME_STAMP bigint 8
EVENT_ID int 4
EVENT_TIME bigint 8
ENFORCER_ID char 32
ENFORCER_TYPE tinyint 1
CLIENT_ID char 32  √  null
REMOTE_HOST nvarchar 512  √  null
ACTION varchar 256  √  null
PERIOD int 4  √  null
EVENT_DESC nvarchar 512  √  null
REMOTE_HOST_MAC varchar 17  √  null
REMOTE_HOST_INFO nvarchar 256  √  null
EXTENDED_INFO nvarchar 2048  √  null
RESERVED_INT1 int 4  √  null
RESERVED_INT2 int 4  √  null
RESERVED_BIGINT1 bigint 8  √  null
RESERVED_BIGINT2 bigint 8  √  null
RESERVED_CHAR1 char 32  √  null
RESERVED_CHAR2 char 32  √  null
RESERVED_VARCHAR1 nvarchar 520  √  null
RESERVED_BINARY varbinary 2000  √  null
LOG_IDX char 32  √  null
HI_EXECUTION_ID varchar 50  √  null
HI_STATUS char 32  √  null
UID_STATUS char 32  √  null
POLICY_STATUS char 32  √  null
RADIUS_STATUS char 32  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012