Help Center> Database Security Service> Best Practices> Database Audit Best Practices> Deploying the Database Audit Agent in a Container> Checking Audit Results
View PDF

Checking Audit Results

Check to ensure the communication between the agent and the database audit instance is normal. Then you can use the database audit function and check audit results.

Verifying the Connection Between the Agent and the Database Audit Instance

Run an SQL statement in the database. Wait for a few minutes, log in to the DBSS console, and view the SQL statement.

  1. Log in to the application server and run an SQL statement (for example, select 1;) in the database.
  2. Log in to the DBSS console.
  3. Go to the SQL statement list, as shown in Figure 1.

    Figure 1 Accessing the SQL statement list

  4. Check whether the SQL statement executed in 1 is displayed in the SQL statement list, as shown in Figure 2.

    If the SQL statement is not displayed, the connection between the agent and the database audit instance is abnormal. Rectify the fault by following the instructions in What Should I Do If the Communication Between the Agent and Database Audit Instance Is Abnormal?
    Figure 2 Viewing SQL statements

Checking Audit Results

By default, database audit complies with a full audit rule, which is used to audit all databases that are successfully connected to database audit. You can check the audit statistics, including the overall audit statistics, risk distribution, session statistics, SQL distribution, and audit reports.

You can also customize audit rules. For details, see Configuring Audit Rules.

  1. View the audit dashboard.

    1. Go to the Dashboard page, as shown in Figure 3.
      Figure 3 Accessing the dashboard
    2. Click the Statements tab to view SQL statement information or the Sessions tab to view session distribution.

  2. View audit reports.

    1. Go to the report management page, as shown in Figure 4.
      Figure 4 Accessing the report management page
    2. In the row containing the desired report template, click Generate Report in the Operation column.
    3. In the displayed dialog box, click to set the start time and end time of the report, and select the database for which you want to generate a report.
    4. Click OK.

      The Reports page is displayed. You can view the report status on this page. After a report is generated, you can preview or download it, as shown in Figure 5.

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

      Figure 5 Previewing or downloading an audit report