The Search feature allows you to query and export the information about SQL statements. This topic describes how to use the Search feature in the SQL insight and audit module.

Prerequisites

  • A database instance is connected to Database Autonomy Service (DAS) and is in the Accessed state.
  • DAS Professional Edition is enabled for the instance. For more information, see Purchase DAS Professional Edition.

Procedure

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Instance Monitoring. On the Instance Monitoring page, click the name of the instance. The instance details page appears.
    a
  3. In the left-side navigation pane of the page that appears, click SQL insight and audit. Then, on the Search tab, specify the following parameters to set the query criteria.
    Parameter Description
    Time range You can specify a time range as the filter condition. Valid values are Last 15 Minutes, Last 1 Hour, Last 3 Hours, Last 6 Hours, Last 12 Hours, or Last 24 Hours.
    Keyword You can specify multiple keywords. Separate each two keywords with a space.
    User You can specify multiple usernames. For example, you can specify the value in the format of user1 user2 user3.
    Database You can specify multiple databases. For example, you can specify the value in the format of DB1 DB2 DB3.
    Operation type You can filter data by operation type, such as SELECT and INSERT.
    Note You can click Enable Advanced Query to specify more parameters to narrow down the search scope.
  4. Click Query. Then, you can view the information about the SQL statements in the Logs section.
    Note To export SQL records, click Export and specify Export fields.