Report Database Schema Parent topic

The report database contains nine tables. These tables are not related to each other.
The following table stores blocked attachment information by category.

Table [tblAttachmentInfo]

Field Name
Data Type
Description
id
Auto increment
Primary key
attachinfo_datetime
datetime
The datetime of summarization
attachinfo_cate_id
int
The category of this counter
attachinfo_value
nvarchar(64)
The value of this counter
attachinfo_count
int
The count of this data category
The following table stores Data Loss Prevention incident information by category.

Table [tblDLPInfo]

Field Name
Data Type
Description
id
Auto increment
Primary key
dlpinfo_datetime
datetime
The datetime of summarization
dlpinfo_cate_id
int
The category of this counter
dlpinfo_value
nvarchar(64)
The value of this counter
dlpinfo _count
int
The count of this data category
The following table stores the total number of detected security risks. This table is used by SCOM.

Table [tblReportCollectionSummary]

Field Name
Data Type
Description
id
Auto increment
Primary key
summary_total_message_count
int
The total message scanned count for this period
summary_total_attachment_count
int
The total attachment scanned count for this period
summary_attachment_blocked_count
int
The blocked attachment count for this period
summary_dlp_filtered_count
int
The filtered-count for this period

Example 1: Get Last Summary Time from table[tblSummary].

SELECT MAX(summary_datetime) AS lastest_datetime
FROM tblSummary;

Example 2: Get SCOM Report Counter

SELECT *
FROM tblReportCollectionSummary.