Table sem5.dbo.AUDIT_REPORT
Keeps the administrator-defined filters for the Audit 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
AUDITFILTER_IDX char 32
USER_ID char 32 ('')
FILTERNAME nvarchar 510 ('')
STARTDATEFROM datetime 16,3 ('19700101') Start time for filter
STARTDATETO datetime 16,3 ('19700101') End time for filter
RELATIVEDATETYPE int 4 ((0)) 0 = past week
1 = past month
2 = past three months
3 = past year
4 = past 24 hours
5 = current month
EVENTTYPE int 4  √  (NULL) 0 = Policy added
1 = Policy deleted
2 = Policy edited
3 = Add shared policy upon system install
4 = Add shared policy upon system upgrade
5 = Add shared policy upon domain creation
SERVERGROUPLIST nvarchar 510 ('') Comma-separated, wild-carded domain names by which to filter
PARENTSERVERLIST nvarchar 510 ('') Comma-separated, wild-carded server names by which to filter
USERLIST nvarchar 510 ('') Comma-separated, wild-carded user names by which to filter
POLICYNAMELIST nvarchar 510 ('') Comma-separated, wild-carded policy names by which to filter
SITELIST nvarchar 510 ('') Comma-separated, wild-carded site names by which to filter
SORTORDER varchar 32 ('TIME_STAMP') Column/Field by which to sort data
SORTDIR varchar 5 ('DESC') DESC = descending sort, ASC = ascending sort
LIMITROWS int 4 ((20)) Number of rows to use for pagination
USERELATIVE char 2 ('on') Use relative dates ('on') or absolute dates
REPORT_IDX int 4 ('0') Not used
REPORTINPUTS nvarchar 128 ('') Special parameters if report needs them
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 flag; 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_AUDITREPORT