Background information
You can view and export historical operation records in the OceanBase Developer Center (ODC) console.
Operation record list
Note
- Any user who owns the system_admin role can manage operation records.
- Operation records are retained permanently.
In the project collaboration window, choose Security Specifications > Operation Records to go to the Operation Records page.
You can click the
icon to manually refresh the list.You can select an option from Execution Duration to filter the operation records by time. Operation records in the last 7 days, 15 days, 30 days, or 6 months, or a custom time range can be queried.
View the basic information displayed in the operation record list.
ParameterDescriptionNo. The sequence number of the operation record. Event Type The type of the operation event. The following types of operation events are supported: personal settings, password management, connection management, script management, database operations, organization configuration, member management, resource group management, data mocking, database changes, import, export, permission application, and task processes. You can click the filter icon 
to filter the operation records by event type.Event Operation The operation performed in the event. You can click the icon to filter the operation records by event operation.IP Address The IP address. You can click the 
icon to search by IP address.Operator The user who performed the operation. You can click the icon to search by operator.Execution Time The time when the operation was performed. By default, the operation records are sorted by execution time. The latest record is displayed at the top. You can click the 
icon to sort the operation records in ascending or descending order of execution time.Execution Result The execution result. Valid values: Succeeded and Failed. You can click the icon to filter the operation records by execution result.Actions Provides options for you to manage the record. Currently, only View is available.
View details of an operation record
In the operation record list, click View in the Actions column of an operation record. The Record Details panel appears.
You can view the event type, event operation, IP address, execution details, executor, execution time, and execution result of the operation record.
Export operation records
Click the 
icon in the upper-left corner of the Operation Records page to go to the Export Operation Records panel.
The following table describes the parameters that you can specify when you export operation records.
Parameter |
Description |
|---|---|
| Operation Time Range | Select the start date and the end date. |
| Event Operation | Select event operations. |
| Connection | Select data sources whose operation records that you want to export. By default, all data sources are selected. |
| Operator | You can specify to export operation records of specific operators. |
| Execution Result | Select the execution result. |
| Export Format | Select the format for exported data. Supported formats are Excel and CSV. |