Queries the audit log tasks of a database instance.
Operation description
Before you call this operation, take note of the following items:
- If you use an Alibaba Cloud SDK or a DAS SDK to call this operation, we recommend that you use the latest version of the SDK.
- If you use an SDK to call operations of DAS, you must set the region ID to cn-shanghai.
Debugging
Authorization information
Request parameters
Parameter | Type | Required | Description | Example |
---|---|---|---|---|
InstanceId | string | No | The ID of the database instance. | r-bp1nti25tc7bq5**** |
NodeId | string | No | The node ID. Note
This parameter is available only for instances that are deployed in the cluster architecture. You can specify this parameter to query the tasks of a specific node. If this parameter is not specified, the tasks of the primary node are returned by default.
| pi-bp1o58x3ib7e6z496 |
Filters | array<object> | No | The filter parameters. | |
Item | object | No | ||
Key | string | No | The name of the filter parameter. Note
For more information about the filter parameters, see the Valid values of Key section of this topic.
| delimiter |
Value | string | No | The value of the filter parameter. | , |
StartTime | long | No | The beginning of the time range to query. This value is a UNIX timestamp representing the number of milliseconds that have elapsed since January 1, 1970, 00:00:00 UTC. | 1596177993000 |
EndTime | long | No | The end of the time range to query. This value is a UNIX timestamp representing the number of milliseconds that have elapsed since January 1, 1970, 00:00:00 UTC. | 1608888296000 |
PageNo | integer | No | The page number. Pages start from page 1. Default value: 1. | 1 |
PageSize | integer | No | The number of entries per page. Valid values: 1 to 100. Default value: 10. | 10 |
Supported parameters and values for Key:
- taskId: the task ID.
- keyWords: the task name.
- status: the task state. Valid values: INIT, RUNNING, FAILED, CANCELED, and COMPLETED.
Response parameters
Examples
Sample success responses
JSON
format
{
"Code": "200",
"Data": {
"List": [
{
"AnalysisTaskFinishTime": 1712751923000,
"AnalysisTaskStatus": "SCAN_ANALYZE_COMPLETED",
"CreateTime": 1681363254423,
"End": 1705975320000,
"Expire": false,
"Filters": [
{
"Key": "delimiter",
"Value": ","
}
],
"InstanceId": "rm-2zew761kf7ho18752",
"LogCount": 99999,
"Name": "test01",
"Progress": 100,
"Result": "https://das-sqllog-download-cn-shanghai.oss-cn-shanghai.aliyuncs.com/la",
"ScanFileSize": 3000,
"Start": 1683859555482,
"Status": "RUNNING",
"TaskId": "9a4f5c4494dbd6713185d87a97aa53e8",
"TaskType": "Export"
}
],
"PageNo": 1,
"PageSize": 10,
"Total": 40
},
"Message": "Successful",
"RequestId": "B6D17591-B48B-4D31-9CD6-9B9796B2****",
"Success": "true"
}
Error codes
HTTP status code | Error code | Error message |
---|---|---|
400 | InvalidParams | The request parameters are invalid. |
403 | NoPermission | You are not authorized to do this action. |
For a list of error codes, visit the Service error codes.