Table sem5.dbo.HISTORYCONFIG
Keeps scheduled report configuration 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
HISTORYCONFIG_IDX char 32
USER_ID char 32 ('') GUID of user who created this scheduled report
TZ_OFFSET int 4 ((0)) Time zone offset from when the admin created the scheduled report so that data can be formatted to the administrator's local time
FILTERNAME nvarchar 510 ('Default') Filter used by this scheduled report
REPORT_IDX varchar 10 ('I-0') Format is Reporttype-number: example I-0 is Virus Definitions Distribution

I = Computer Status Report
0 = Virus Definitions Distribution
1 = Computers Not Checked Into Server
2 = Symantec Endpoint Protection Product Versions
3 = Intrusion Prevention Signature Distribution
4 = Client Inventory
5 = Compliance Status Distribution
6 = Client Online Status
7 = Clients With Latest Policy
8 = Client Count by Group
9 = Security Status Summary
10 = Protection Content Versions
11 =Client Migration
100 = Client Software Rollout (Snapshots)
101 = Clients Online/Offline Over Time (Snapshots)
102 = Clients With Latest Policy Over Time (Snapshots)
103 = Non-Compliant Clients Over Time (Snapshots)
104 = Virus Definition Rollout (Snapshots)

A = Audit Report
0 = Policies Used

B = Application and Device Control Report
0 = Top Groups With Most Alerted Application Control Logs
1 = Top Targets Blocked
2 = Top Devices Blocked


C = Compliance Report
0 = Network Compliance Status
1 = Compliance Status
2 = Clients by Compliance Failure Summary
3 = Compliance Failure Details
4 = Non-compliant Clients by Location

F = Network Threat Protection Report
0 = Top Targets Attacked
1 = Top Sources of Attack
2 = Top Types of Attack
3 = Top Blocked Applications
4 = Attacks Over Time
5 = Security Events by Severity
6 = Blocked Applications Over Time
7 = Traffic Notifications Over Time
8 = Top Traffic Notifications
9 = Full Report

R = Risk Report
0 = Infected and At Risk Computers
1 = Detection Action Summary
2 = Risk Detections Count
3 = New Risks Detected in the Network
4 = Top Risk Detections Correlation
5 = Risk Distribution Summary
6 = Risk Distribution Over Time
8 = Proactive Threat Detection Results
9 = Proactive Threat Distribution
10 = Proactive Threat Detection Over Time
11 = Action Summary for Top Risks
12 = Number of Notifications
14 = Number of Notifications Over Time
13 = Weekly Outbreaks
7 = Comprehensive Risk Report

S = Scan Report
0 = Scan Statistics Histogram
1 = Computers by Last Scan Time
2 = Computers Not Scanned

Y = System Report
0 = Top Clients That Generate Errors
1 = Top Servers That Generate Errors
2 = Top Enforcers That Generate Errors
3 = Database Replication Failures Over Time
4 =Site Status Report
STARTTIME datetime 16,3 ('19700101') When to start generating the report. This establishes its scheduled time within the repeat schedule.
LASTRUN bigint 8 ((0)) When the report got generated last in GMT
RUNHOURS int 4 ((24)) Repeat schedule for this report in hours, for example:
1 = Every 1 hour
24 = Every 1 day
168 = Every week
720 = Every month
NAME nvarchar 510 ('') Name of this scheduled report
EMAIL nvarchar 510 ('') Comma-separated list of emails to send the report to
DESCRIPTION nvarchar 510 ('') Admin-provided description for this report
DISABLED tinyint 1 ((0)) Scheduled report disabled: 0 = No, 1 = Yes
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
IS_MAIL_TO_SYS_ADMIN tinyint 1 ('1') The flag for mailing to be sent to system administrator.
FILTER_USER_ID char 32  √  ('') Filter user ID
TZ_NAME varchar 255 ('') Time zone when admin created the notification so that e-mailed reports can display dates in admin's local time zone.

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
HISTORYCONFIG_IDX Primary key Asc PK_HISTORYCONFIG