Skip to main content

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 DevOps Pro, you can view audit log records within the last 3 months. Under DevOps Enterprise, 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 DevOps Pro or DevOps Enterprise. 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 Administrator. For more information about roles, see Roles.

View audit logs​

  1. Log in to the NineData Console.

  2. In the left navigation pane, click Account, then click Audit Log.

    tip

    If you do not see Account, 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 Operation Logs or SQL Logs.

    • Operation Logs: 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 User, Module, Type, Time, and Event Object. After configuring the filter items, click Search to quickly locate the required operation record. If the recorded Event Object is a specific instance ID, you can directly click to jump to it.
    • SQL Logs: 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 User, Module, Type, Datasource, Database, Tables, Time, SQL Type and Query (SQL statement). After configuring the filter items, click Search to quickly locate the required SQL execution record. Click Details on the right side of the target record to view all information of that record.

Download SQL Execution Logs​

SQL 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 Account > Audit Log.

    tip

    If Account 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 SQL Logs tab. Use the filter feature to locate the target SQL execution records, then click Download on the right side of the page and select either Current Page or All as needed.

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