Table sem5.dbo.V_AGENT_PACKET_LOG
Query packet traffic 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
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
LOCAL_PORT int 4  √  null
REMOTE_PORT int 4  √  null
TRAFFIC_DIRECTION tinyint 1  √  null
BLOCKED tinyint 1
APP_NAME nvarchar 512  √  null
ALERT int 4  √  null
SEND_SNMP_TRAP tinyint 1  √  null
EVENT_DATA varbinary 2000  √  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 2000  √  null
LOG_IDX char 32  √  null
LOCAL_HOST_IPV6 varchar 32  √  null
REMOTE_HOST_IPV6 varchar 32  √  null
RULE_NAME nvarchar 512  √  null
LOCAL_HOST_IP_TEXT varchar 123  √  null
REMOTE_HOST_IP_TEXT varchar 123  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012