Table sem5.dbo.SCANREPORT
Keeps the administrator-defined filters for the Scan 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
SCANFILTER_IDX char 32
USER_ID char 32 ('')
FILTERNAME nvarchar 510 ('')
STARTTIMEFROM datetime 16,3 ('19700101') Start date
STARTTIMETO 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
DURATION int 4 ('0') Length of the scan
FILESCANNED bigint 8 ('0') Number of files scanned
THREATS int 4 ('0') Number of risks the scan found
FILESINFECTED bigint 8 ('0') Number of files the scan found
SCANSTARTMESSAGE nvarchar 510 ('%') Scan description
STATUS varchar 32 ('%') Scan status as hard-coded English key: Completed, Cancelled, Started, % means no filter (all)
SERVERGROUPLIST nvarchar 510 ('%') Comma-separated, wild-carded list of server groups by which to filter
CLIENTGROUPLIST nvarchar 510 ('%') Comma-separated, wild-carded list of client groups by which to filter
PARENTSERVERLIST nvarchar 510 ('%') Comma-separated, wild-carded list of parent servers by which to filter
COMPUTERLIST nvarchar 1024 ('%') Comma-separated, wild-carded list of computers by which to filter
IPADDRESSLIST nvarchar 510 ('%') Comma-separated, wild-carded list of IP addresses by which to filter
USERLIST nvarchar 510 ('%') Comma-separated, wild-carded list of users by which to filter
LASTCOLUMN varchar 32 ('SERVERGROUP') Not used
SORTORDER varchar 32 ('STARTDATETIME') I.Computer'
'P.Parentserver'
'G.Clientgroup'
'C.Clientuser'
'S.Servergroup'
'SC.Startdatetime'
'SC.Duration'
'SC.Totalfiles' (total files scanned)
'SC.Threats'
'SC.Infected' (total files infected)
SORTDIR varchar 5 ('DESC') Sort direction; desc = Descending, asc = Ascending
LIMITROWS int 4 ('0') 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 510 ('') 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))
R_OS_TYPE int 4  √  ((-1)) Operating System type running on the client computer:

Analyzed at Mon Oct 29 12:07 PDT 2012

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