Checking Audit Results

Updated on 2022-11-23 GMT+08:00

View PDF

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.

Log in to the application server and run an SQL statement (for example, select 1;) in the database.
Log in to the DBSS console.
In the navigation pane, choose Dashboard.
Click the Statements tab.
Check whether the SQL statement executed in 1 is displayed in the SQL statement list.

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 Do I Do If the Communication Between the Agent and Database Audit Instance Is Abnormal?

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.

View the audit dashboard.
1. Go to the Dashboard page, as shown in Figure 1.
  Figure 1 Accessing the dashboard
2. Click the Statements tab to view SQL statement information or the Sessions tab to view session distribution.
View audit reports.
1. Go to the report management page, as shown in Figure 2.
  Figure 2 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, preview or download the report, as shown in Figure 3.
  
  NOTICE:
  
  To preview a report online, use Google Chrome or Mozilla FireFox.
  
  Figure 3 Previewing or downloading an audit report