Table sem5.dbo.ENFORCER_CLIENT_LOG_1
Keeps client 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.
DOMAIN_ID char 32 Not used (logged as '00000000000000000000000000000000')
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 No event IDs defined, logged as 0
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
CLIENT_ID char 32  √  null Not used (logged as '')
REMOTE_HOST nvarchar 512  √  null Remote host name
ACTION varchar 256  √  null Enforcer's action on this client (hard-coded English string used as lookup)

Authenticated = Agent's UID is correct
Rejected = Agent's UID is wrong or there's no agent running
Disconnected = Agent disconnects from Enforcer or Enforcer service stops
Passed = Agent has passed Host Integrity check
Failed = Agent has failed Host Integrity check
PERIOD int 4  √  null The period in seconds that the Enforcer will take action on the client. Only valid when action is equal to Rejected and Disconnected. For other actions, this field must be 0.
EVENT_DESC nvarchar 512  √  null Description of the event. Usually, first line of the description is treated as the summary.
REMOTE_HOST_MAC varchar 17  √  null Remote host MAC address
REMOTE_HOST_INFO nvarchar 256  √  null Remote host information
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 For PeerToPeer Enforcer log records, this field contains the host name of the client acting as the Enforcer.
RESERVED_BINARY varbinary 2000  √  null
LOG_IDX char 32  √  null
HI_EXECUTION_ID varchar 50  √  null Execution ID that SNAC agent generates for each HI execution
HI_STATUS char 32  √  null Host Integrity Status of SNAC agent
UID_STATUS char 32  √  null Indicates UID status whether Authenticated, Failed etc
POLICY_STATUS char 32  √  null Policy Status such as Passed, Failed, Unknown etc
RADIUS_STATUS char 32  √  null Radius Status

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
USN Performance Asc I_ENFORCER_CLIENT_LOG_1
HI_EXECUTION_ID Performance Asc I_ENFORCER_CLIENT_LOG_1_HI_EXECUTION_ID
EVENT_ID Performance Asc I_ENFORCER_CLIENT_LOG_1_ID
LOG_IDX Performance Asc I_ENFORCER_CLIENT_LOG_1_LOG_IDX
EVENT_TIME + ENFORCER_ID Performance Asc/Asc I_ENFORCER_CLIENT_LOG_1_TIME_PLUS