Table sem5.dbo.V_ALERTS
Query risk and TruScan events with human-readable IP address information

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
IDX char 32
ALERT_IDX int 4
COMPUTER_IDX char 32
SOURCE varchar 50
VIRUSNAME_IDX char 32
NOOFVIRUSES int 4
FILEPATH nvarchar 510
DESCRIPTION nvarchar 510
ACTUALACTION_IDX int 4
REQUESTEDACTION_IDX int 4
SECONDARYACTION_IDX int 4
ALERTDATETIME datetime 16,3
ALERTINSERTTIME datetime 16,3
SERVERGROUP_IDX char 32
USER_NAME nvarchar 128
PARENTSERVER_IDX char 32
CLIENTGROUP_IDX char 32
SOURCE_COMPUTER_NAME nvarchar 128
SOURCE_COMPUTER_IP bigint 8
MOTHER_IDX char 32
LAST_LOG_SESSION_GUID char 32
ALERTENDDATETIME datetime 16,3
HPP_APP_IDX varchar 32
SITE_IDX char 32  √  null
VBIN_ID bigint 8
SCAN_ID bigint 8
USN bigint 8
TIME_STAMP bigint 8
DELETED tinyint 1
LOCAL_HOST_IP bigint 8  √  null
AV_PRODUCT varchar 256  √  null
AV_PRODUCT_VERSION varchar 64  √  null
STATUS varchar 6  √  null
SOURCE_COMPUTER_IP_TEXT varchar 123  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012