Help Center/ Database Security Service/ User Guide/ Database Audit/ Report Center
Updated on 2026-07-07 GMT+08:00
View PDF
Share

Report Center

By default, database audit complies with a full audit rule, which is used to audit all databases that are connected to the database audit instance.

After connecting a database to the audit instance, you can generate reports immediately or on a schedule. You can preview, download, or delete reports directly from the console, as well as view report templates and historical results.

Constraints and Limitations

To preview a report online, use Google Chrome or Mozilla Firefox.

Prerequisites

  • The database audit instance is in the Running state.
  • For details about how to enable database audit, see Enable Database Audit.

Supported Report Types

Database audit provides eight types of report templates. Table 1 lists the report names. You can generate reports and set report tasks as needed.

Table 1 Description

Template Name

Report Type

Description

Database Security General Report

Overview report

This report provides the overall audit status of the database, including risks, sessions, and login status to better manage databases.

Database Security Compliance Report

Compliance report

This report helps database administrators and auditors detect abnormal behaviors, locate problems, and manage information.

SOX Report

Compliance report

This report complies with the Sarbanes-Oxley Act (SOX) to provide statistics on and evaluate database operations. It helps database administrators and auditors identify abnormal behaviors, locate problems, and manage information.

Database Server Analysis Report

Database report

This report provides the following data to evaluate database server performance: active user counts, unique source IP counts, database login and request analysis, and total database usage duration.

Client IP Address Analysis Report

Client report

This report provides statistics on client applications, database users, and SQL statements collected from user IP addresses.

DML Command Report

Database operation report

This report analyzes user and privileged operations based on DML commands.

DDL Command Report

Database operation report

This report analyzes user and privileged operations based on DDL commands.

DCL Command Report

Database operation report

This report analyzes user and privileged operations based on DCL commands.

Accessing the Reports Page

  1. Log in to the DBSS console.
  2. Click in the upper left corner on the displayed page and select a region.
  3. In the navigation tree on the left, choose Reports.
  4. In the Instance drop-down list, select an instance.

Viewing a Report Template

  1. Click the Report Management tab.
  2. View the report template information. For details, see Table 2.

    Figure 1 Viewing the report template list
    Table 2 Report template parameters

    Parameter

    Description

    Template Name

    Name of a report template. For details, see Supported Report Types.

    Related Database

    Database associated with the report.

    Type

    Type of a report, which is automatically generated by the system.

    • Compliance report
    • Overview report
    • Database report
    • Client report
    • Database operation report

    Description

    Table description.

    Task Status

    You can enable or disable scheduled tasks, or set their frequency to daily, weekly, or monthly.

    Operation

    Operation that can be performed on a report.

Generating a Report

You can generate reports immediately or periodically, with fully customizable scheduling, frequencies, and formats. Simply select the generation mode that suits your requirements.

  1. Click the Report Management tab.
  2. In the Operation column of a report template, click Generate Report.

    Figure 2 Report template list

  3. In the displayed dialog box, click to set the start time and end time of the report, and select a database.

    Figure 3 Generate Report

  4. Click OK.
  1. Click the Report Management tab.
  2. Locate the target template and click Schedule Task in the Operation column, as shown in Figure 4.

    Figure 4 Setting a task

  3. In the displayed dialog box, set the parameters of the scheduled task, as shown in Figure 5. For details about related parameters, see Table 3.

    Figure 5 Setting a scheduled task
    Table 3 Parameters for setting a task

    Parameter

    Description

    Example Value

    Enable Task

    Status of a scheduled task.

    • Enabled
    • Disabled

    -

    Message Notifications

    Enables or disables notifications.

    Notifications are sent and billed by SMN in pay-per-use mode. Fees vary depending on regions and billing items. For details, see SMN Pricing Details.

    • Enabled
    • Disabled

    -

    SMN Topic
    • Select an existing topic from the drop-down list or click View to create a topic. For details, see Creating a Topic.
    • You can add multiple subscriptions to a topic and select multiple subscription endpoints (such as SMS messages and emails). For details, see Adding a Subscription.

    For more information about topics and subscriptions, see the Simple Message Notification User Guide.

    -

    Report Type

    Type of a report. The options are as follows:

    • Daily
    • Weekly
    • Monthly

    Weekly

    Execution Mode

    Execution mode of the report. The options are as follows:

    • Once
    • Periodically

    Periodically

    Time

    Time when the report is executed

    10:00

    Database

    Database for which you want to execute the report task

    -

  4. Click OK.

Viewing Report Results

  1. Click the Reports tab page. In the search box above the list, you can select a filter or enter a keyword to search for a specified report result.
  2. View the report results. For details, see Table 4.

    Figure 6 Previewing or downloading an audit report
    Table 4 Report result parameters

    Parameter

    Description

    Report Name

    Name of a report.

    Associated Database

    Database associated with the generated report.

    Report Type

    Type of a report.

    • A real-time report is automatically generated by the system.

    Generated

    Time a report was generated.

    Format

    Format of a report. Only PDF is supported.

    Status

    Progress of report generation.

    Operation

    Operation that can be performed on a report.

Previewing or Downloading an Audit Report

Before previewing or downloading an audit report, ensure the generation progress in its Status is 100%.

  1. Click the Reports tab page.
  2. Locate the target template, and click Preview or Download in the Operation column to preview or download the report. See Figure 7..

    Figure 7 Previewing or downloading an audit report

Deleting an Audit Report

Before deleting an audit report, ensure the generation progress in its Status is 100%.

  1. Click the Reports tab page.
  2. In the Operation column of a report, click Delete, as shown in Figure 8.

    Figure 8 Previewing or downloading an audit report

  3. In the displayed dialog box, enter DELETE and click OK.

    If a report is deleted, you must regenerate it manually to view its results again.

Parent Topic: Database Audit