Table sem5.dbo.V_AGENT_SECURITY_LOG
Query security events for agents

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
SERVER_ID char 32
GROUP_ID char 32
COMPUTER_ID char 32
TIME_STAMP bigint 8
EVENT_ID int 4
EVENT_TIME bigint 8
SEVERITY int 4
AGENT_ID char 32  √  null
HARDWARE_KEY char 32  √  null
HOST_NAME nvarchar 512  √  null
LOCAL_HOST_IP bigint 8  √  null
REMOTE_HOST_IP bigint 8  √  null
REMOTE_HOST_NAME nvarchar 128  √  null
TRAFFIC_DIRECTION tinyint 1  √  null
NETWORK_PROTOCOL tinyint 1  √  null
HACK_TYPE int 4  √  null
BEGIN_TIME bigint 8  √  null
END_TIME bigint 8  √  null
REPETITION int 4  √  null
APP_NAME nvarchar 512  √  null
EVENT_DESC nvarchar 4000  √  null
EVENT_DATA varbinary 3000  √  null
ALERT tinyint 1  √  null
SEND_SNMP_TRAP tinyint 1  √  null
LOCAL_HOST_MAC varchar 18  √  null
REMOTE_HOST_MAC varchar 18  √  null
LOCATION_NAME nvarchar 512  √  null
USER_NAME nvarchar 512  √  null
DOMAIN_NAME nvarchar 512  √  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 1900  √  null
AGENT_SECURITY_LOG_IDX char 32  √  null
LOCAL_HOST_IPV6 varchar 32  √  null
REMOTE_HOST_IPV6 varchar 32  √  null
LOCAL_PORT int 4
REMOTE_PORT int 4
CIDS_SIGN_ID bigint 8
STR_CIDS_SIGN_ID nvarchar 520
CIDS_SIGN_SUB_ID bigint 8
INTRUSION_URL nvarchar 4200
INTRUSION_PAYLOAD_URL nvarchar 4200
HI_EXECUTION_ID varchar 50  √  null
AGENT_VERSION nvarchar 128  √  null
PROFILE_SERIAL_NO varchar 64  √  null
LOCAL_HOST_IP_TEXT varchar 123  √  null
REMOTE_HOST_IP_TEXT varchar 123  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012