Table sem5.dbo.SCANS
Keeps the antivirus scan events

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
SCAN_IDX char 32
SCAN_ID bigint 8 ((0)) Scan ID provided by agent
STARTDATETIME datetime 16,3 ('19700101') Start time for scan
STOPDATETIME datetime 16,3 ('19700101') Stop time for scan
STATUS varchar 20 ('started') Scan status as hard-coded English key:
completed = Completed
cancelled = Canceled
started = Started
DURATION int 4 ((0)) Length of the scan in seconds
COMPUTER_IDX char 32 ('') Foreign key to SEM_COMPUTER.COMPUTER_ID
CLIENTUSER1 nvarchar 128 ('') User who was logged in when scan started
CLIENTUSER2 nvarchar 128 ('') User who was logged in when scan ended
SERVERGROUP_IDX char 32 ('') Pointer to table IDENTITY_MAP (domain GUID)
PARENTSERVER_IDX char 32 ('') Pointer to table IDENTITY_MAP (server GUID)
CLIENTGROUP_IDX char 32 ('') Pointer to table IDENTITY_MAP (group GUID)
MESSAGE1 nvarchar 510 ('') Scan message when scan started
MESSAGE2 nvarchar 510 ('') Scan message when scan ended
THREATS bigint 8 ((0)) Number of threats that the scan found
INFECTED bigint 8 ((0)) Number of files the scan found infected
TOTALFILES bigint 8 ((0)) Number of files scanned
OMITTED bigint 8 ((0)) Number of files omitted
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
SCAN_TYPE varchar 64 ('') Type of scan:
ScanNow_Quick = Active Scan
ScanNow_Full = Full Scan
ScanNow_Custom = Admin-defined Scan
COMMAND_ID varchar 32  √  (NULL) Pointer to table SEM_JOB; command ID that kicked off this scan (if any)
VSIC_SCAN tinyint 1 ((0))

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
SCAN_IDX Primary key Asc PK_SCANS
CLIENTGROUP_IDX Performance Asc I_SCANS_CLIENTGROUP_IDX
COMPUTER_IDX + SCAN_ID Performance Asc/Asc I_SCANS_COMPUTER_IDX_PLUS
PARENTSERVER_IDX Performance Asc I_SCANS_PARENTSERVER_IDX
SERVERGROUP_IDX Performance Asc I_SCANS_SERVERGROUP_IDX
STARTDATETIME + DURATION + THREATS + INFECTED + TOTALFILES + COMPUTER_IDX Performance Asc/Asc/Asc/Asc/Asc/Asc I_SCANS_STARTDATETIME_PLUS
STATUS Performance Asc I_SCANS_STATUS
STOPDATETIME + COMPUTER_IDX Performance Asc/Asc I_SCANS_STOPDATETIME_PLUS