Table sem5.dbo.ALERTFILTER
The administrator-defined filters for the notification log.

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
ALERTFILTER_IDX char 32
USER_ID char 32 ('') User ID
FILTERNAME nvarchar 510 ('') User-specified name of filter
STARTDATEFROM datetime 16,3 ('19700101') Start date
STARTDATETO datetime 16,3 ('19700101') End date
RELATIVEDATETYPE int 4 ((0)) 0 = past week
1 = past month
2 = past three months
3 = past year
4 = past 24 hours
5 = current month
FILTERACKNOWLEDGED nvarchar 510 ('') 1 = Acknowledged
0 = Unacknowledged
FILTERSUBJECT nvarchar 510 ('') AF = Authentication failure
CL = Client list changed
CS = Client security alert
ED = Enforcer Down
WL = Forced or commercial application detected
LA = New learned application
NV = New risk detected
NS = New software package
VO = Virus outbreak
DF = Server health
1V = Single risk event
SE = System event
UM = Unmanaged computer
ID = Virus definitions out-of-date
FILTERCREATEDBY nvarchar 510 ('') GUID of the administrator who created any alert filters
LASTCOLUMN varchar 255 ('')
SERVERGROUP nvarchar 510 ('') Not used
CLIENTGROUP nvarchar 510 ('') Not used
PARENTSERVER nvarchar 510 ('') Not used
COMPUTER nvarchar 510 ('') Not used
THREATNAME nvarchar 510 ('') Not used
THREATCATEGORY varchar 255 ('') Not used
SOURCE varchar 255 ('') Not used
ACTUALACTION varchar 255 ('') Not used
LIMITROWS int 4 ((20)) Number of rows to use for pagination
USERELATIVE char 2 ('on') Use relative dates ('on') or absolute dates
REPORTINPUTS nvarchar 128 ('') Special parameters if report needs them
NOTIFICATIONNAME nvarchar 510 ('') Name of selected notification condition
USN bigint 8 ((1)) A USN-based serial number; this ID is not unique.
TIME_STAMP bigint 8 ((0)) The time when the event is logged into system (GMT), which is server side time
DELETED tinyint 1 ((0)) Deleted row: 0 = not deleted, 1 = deleted

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
USER_ID + FILTERNAME Primary key Asc/Asc PK_ALERTFILTER