Skip to main content

View audit logs

Audit logs help system administrators review activity in the NineData console, investigate user changes, and trace security events in an organization.

Overview​

NineData audit logs record who performed what action on which object and when the action occurred. Audit records usually include the following information:

  • Who: User ID, organization, IP address, etc.
  • When: The timestamp of the operation.
  • Object: The resource affected by the operation, such as a data source, database, table, column, user, backup task, replication task, or comparison task.
  • What: The operation performed in the NineData console.

The details displayed in each record depend on the operation object and event type.

Notes​

NineData does not record these operations:

  • Viewing non-sensitive information, such as opening a replication task list.

  • Personal workspace actions, such as saving SQL or viewing SQL operations in SQL Console.

  • Database operations triggered by tasks, such as write operations initiated by a data replication task on the target data source.

  • In DevOps Pro, audit logs are retained for the last 3 months.

  • In DevOps Enterprise, audit logs are retained for the last 3 years.

Before you begin​

  • 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 details, see Roles.

Procedure​

View audit logs​

  1. Sign in to the NineData Console.

  2. Open Account > Audit Log.

    tip

    If Account is not displayed, make sure your console is in organization mode. To switch from personal mode to organization mode, see Switch to organization.

  3. On the audit log page, switch between tabs to view Operation Logs or SQL Logs.

    • Operation Logs: Records user actions in the NineData console. Filter records by User, Module, Type, Time, and Event Object. After configuring filters, click Search. If Event Object is a specific instance ID, click the ID to open the instance.
    • SQL Logs: Records SQL statements that users run against data sources. Filter records by User, Module, Type, Datasource, Database, Tables, Time, SQL Type, and Query. After configuring filters, click Search. Click Details in the target record to view the full record.
    • OpenAPI Request Logs: Records OpenAPI calls, including call time, user name, RequestID, API name, and call status. Filter records by User, Time, and specific APIs.

Download logs​

Download Operation Logs and SQL Logs records in Excel format for offline review or retention.

  1. Sign in to the NineData Console.

  2. Open Account > Audit Log.

    tip

    If Account is not displayed, make sure your console is in organization mode. To switch from personal mode to organization mode, see Switch to organization.

  3. On the audit log page, click the Operation Logs or SQL Logs tab. Filter the target records, click Download, and select Current Page or All.

  4. Click the Report Download tab. When the target report Status changes to Success, click Download in the Actions column.

Result​

Review audit events in the console or download filtered log records as an Excel file.