Table sem5.dbo.ENFORCER_SYSTEM_LOG_1
Keeps client system activities that occur in 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 A USN-based serial number; this ID is not unique.
SITE_ID char 32 GUID of the site 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  √  null An event ID from send agent: (in hex)
0x101 = Connected to management server
0x102 = Lost connection to management server
0x103 = Applied policy downloaded from management server
0x104 = Failed to apply policy downloaded from management server
0x105 = Applied management server configuration
0x106 = Failed to apply management server configuration
0x107 = Applied management server configuration
0x108 = Failed to apply management server configuration
0x110 = Registered to NAP management server
0x111 = Unregistered from NAP management server
0x112 = Failed to register to NAP management server
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 management server
0x603 = Failed to export policy downloaded from management server
0x701 = Incorrect customized attribute
EVENT_TIME bigint 8 The event generated time (GMT)
ENFORCER_ID char 32 GUID of the Enforcer
ENFORCER_TYPE tinyint 1 0 = Gateway Enforcer
1 = LAN Enforcer
2 = DHCP Enforcer
3 = Integrated Enforcer
4 = NAP Enforcer
5 = PeerToPeer Enforcer
SEVERITY int 4 The type of event. Possible values are:
0 = INFO
1 = WARNING
2 = ERROR
3 = FATAL
EVENT_DESC nvarchar 512  √  null Description of the event. Usually, the first line of the description is treated as the summary.
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 Log index unique ID

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
USN Performance Asc I_ENFORCER_SYSTEM_LOG_1
EVENT_ID Performance Asc I_ENFORCER_SYSTEM_LOG_1_ID
LOG_IDX Performance Asc I_ENFORCER_SYSTEM_LOG_1_LOG_IDX
EVENT_TIME Performance Asc I_ENFORCER_SYSTEM_LOG_1_TIME