Updated on 2025-04-29 GMT+08:00

Viewing Trend Analysis

After connecting the database to the database audit instance, you can view the statement trend analysis (including statement quantity, session statistics, and SQL distribution) and risk trend analysis (including risk distribution, SQL injections, and risky operations).

Prerequisites

  • This function is supported by database instance of 23.05.23.193055 and later versions.
  • The database audit instance is in the Running state.
  • For details about how to enable database audit, see Enable Database Audit.

Procedure

  1. Log in to the management console.
  2. Select a region, click , and choose Security & Compliance > Database Security Service. The Dashboard page is displayed.
  3. In the navigation tree on the left, choose Data Reports. The Data Reports page is displayed.
  4. Click the Trends tab. The trend analysis page is displayed.
  5. In the Instance drop-down list, select the instance whose audit information you want to view.
  6. View the overall trend of the database.

    • Click Re-analyze on the right of the console.
      Figure 1 Re-analyze
    • Select All databases or a specified database from the Database drop-down list to view the statement and risk trend analysis of all databases or a specified database in the instance.
    • Select Last 30 minutes, 1 hour, Today, 7 days, or 30 days, or click to customize start time and end time to view the statement and risk trend analysis in a specified period.
    Figure 2 Statement quantity
    Figure 3 Session statistics
    Figure 4 SQL distribution
    Figure 5 Risk distribution
    Figure 6 SQL injections
    Figure 7 Risky operations