Table sem5.dbo.SERVER_CLIENT_LOG_1
Keeps client 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.
DOMAIN_ID char 32  √  null GUID of the domain to which the log belongs
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 client activity event:
1 = Registration succeeded
2 = Registration failed
3 = Client reconnected
4 = Client disconnected
5 = Downloaded policy
6 = Downloaded Intrusion Prevention policy
7 = Downloaded sylink.xml
8 = Downloaded auto-upgrade file
9 = Server received log
10 = Log processing failed
11 = Server received learned application
12 = Server received client information
13 = Client information processing failed
14 = Hardware identity change
15 = Downloaded File Fingerprint list
20 = Downloaded content package
22 = Downloaded command
AGENT_ID char 32 GUID of the agent
HOST_NAME nvarchar 512  √  null Computer name of the client
USER_NAME nvarchar 512  √  null Login user name of the client
DOMAIN_NAME nvarchar 512  √  null Domain name of the client
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
CLIENT_ID char 32  √  null GUID of the client to which the log belongs

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
USN Performance Asc I_SERVER_CLIENT_LOG_1
CLIENT_ID Performance Asc I_SERVER_CLIENT_LOG_1_CLIENT_ID
EVENT_ID Performance Asc I_SERVER_CLIENT_LOG_1_ID
LOG_IDX Performance Asc I_SERVER_CLIENT_LOG_1_LOG_IDX
TIME_STAMP Performance Asc I_SERVER_CLIENT_LOG_1_TIME