Table sem5.dbo.SERVER_ENFORCER_LOG_2
Keeps Enforcer activities that occur in server

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 A USN-based serial number; this ID is not unique.
SITE_ID char 32 GUID of the site to which the log belongs
SERVER_ID char 32 GUID of the server to which the log belongs
TIME_STAMP bigint 8 The time when the event is logged into system (GMT), which is server side time
EVENT_ID int 4 A unique ID of the Enforcer activity:
0x101 = Connected to Policy Manager
0x102 = Lost connection to Policy Manager
0x103 = Applied policy downloaded from Policy Manager
0x104 = Failed to apply policy downloaded from Policy Manager
0x105 = Applied Policy Manager configuration
0x106 = Failed to apply Policy Manager configuration
0x107 = Applied Policy Manager configuration
0x108 = Failed to apply Policy Manager configuration
0x201 = Enforcer started
0x202 = Enforcer stopped
0x203 = Enforcer paused
0x204 = Enforcer resumed
0x205 = Enforcer disconnected from server
0x301 = Enforcer failover enabled
0x302 = Enforcer failover disabled
0x303 = Enforcer in standby mode
0x304 = Enforcer in primary mode
0x305 = Enforcer short
0x306 = Enforcer loop
0x401 = Forward engine pause
0x402 = Forward engine start
0x403 = DNS Enforcer enabled
0x404 = DNS Enforcer disabled
0x405 = DHCP Enforcer enabled
0x406 = DHCP Enforcer disabled
0x407 = Allow all enabled
0x408 = Allow all disabled
0x501 = Seat number change
0x601 = Failed to create policy parser
0x602 = Failed to import policy downloaded from Policy Manager
0x603 = Failed to export policy downloaded from Policy Manager
0x701 = Incorrect customized attribute
ENFORCER_ID char 32 GUID of the Enforcer
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

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
USN Performance Asc I_SERVER_ENFORCER_LOG_2
ENFORCER_ID Performance Asc I_SERVER_ENFORCER_LOG_2_ENFORCER_ID_PLUS
EVENT_ID Performance Asc I_SERVER_ENFORCER_LOG_2_ID
LOG_IDX Performance Asc I_SERVER_ENFORCER_LOG_2_LOG_IDX
TIME_STAMP + EVENT_ID + USN + LOG_IDX Performance Asc/Asc/Asc/Asc I_SERVER_ENFORCER_LOG_2_TIME_PLUS