View audit logs

NineData supports the audit log feature. By viewing the audit log, system administrators can track the operation history that has occurred in the console, in order to analyze the changes made by users and the occurrence of security incidents.

Function Description

The audit log feature of NineData mainly records who did what to which object at when. Specifically, the audit log usually includes the following information:

• Who: User ID, organization, IP address, etc.
• When: Timestamp, records the time when the operation occurred.
• Object: The object of the operation, usually a data resource (data source, database, table, column, etc.), user, task (backup, replication, comparison, etc.).
• What: The operation performed, which basically covers all operations performed on the NineData console.

The audit log records the user's operations based on the above information and displays the details. Depending on the operation object, the audit log will display specific content.

Notes

• The following operations will not be recorded:

  • Viewing operations for non-sensitive information, such as: a user viewed the list of replication tasks.

  • Personal-related operations, such as: a user saved SQL, viewed SQL operations in the SQL Console.

  • Database operations triggered by specific tasks, such as: a data replication task initiated a write operation to the target data source.

• Under , you can view audit log records within the last 3 months. Under , you can view audit log records within the last 3 years.

Prerequisites

• You have created or joined an organization, and this organization has subscribed to either or . Please ensure that your annual or monthly subscription is still active. For more information, please refer to Manage Organizations.
• Your current account has switched to the target organization. For more information, please refer to Switching to an Organization.

• Your role is . For more information about roles, see Roles.

View audit logs

1. Log in to the NineData Console.

2. In the left navigation pane, click , then click .

   tip

   If you do not see , make sure that your console is in organization mode. To switch from personal mode to organization mode, see Switching to an Organization.

3. On the audit log page, you can switch between tabs to view or .

   • : Records the actions performed by users in the NineData Console. You can use the filter function to quickly find the target operation record. The filterable items include , , , , and . After configuring the filter items, click to quickly locate the required operation record. If the recorded is a specific instance ID, you can directly click to jump to it.
   • : Records the modifications made by users to data sources in the form of SQL statements. You can use the filter function to quickly find the target SQL execution record. The filterable items include , , , , , , , and Query (SQL statement). After configuring the filter items, click to quickly locate the required SQL execution record. Click on the right side of the target record to view all information of that record.

Download SQL Execution Logs

supports downloading in Excel format for easy sharing and management.

1. Log in to the NineData Console.

2. In the left navigation bar, click > .

   tip

   If is not found, make sure your console is in organization mode. For information on switching from personal mode to organization mode, see Switch to Organization Mode.

3. On the Audit Log page, click the tab. Use the filter feature to locate the target SQL execution records, then click on the right side of the page and select either or as needed.

4. Click the tab, wait for the target report’s to change to , then click in the column on the right to download.