Retrieves a list of audit alert logs.
Operation description
This operation retrieves a list of data audit alert logs, which you can use to search for and handle alerts.
QPS limit
The queries per second (QPS) limit for a single user is 10. If you exceed this limit, the system throttles your API calls. This may affect your business. Plan your calls accordingly.
Try it now
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
yundun-sddp:DescribeAuditLogs |
none |
*All Resource
|
|
None |
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| Lang |
string |
No |
The language of the request and response. Default value: zh_cn. Valid values:
|
zh |
| UserName |
string |
No |
The username. |
admin |
| ClientIp |
string |
No |
The IP address of the client. |
10.*.*.94 |
| ClientUa |
string |
No |
The client type. |
mysql |
| InstanceName |
string |
No |
The name of the data asset instance. |
i-2zeftaaq4gqcqb9kfkzg |
| DatabaseName |
string |
No |
The name of the database. |
bose_o2o_data |
| StartTime |
integer |
No |
The start time of the alert log. This value is a UNIX timestamp in milliseconds. |
1616068534877 |
| EndTime |
integer |
No |
The end time of the alert log. This value is a UNIX timestamp in milliseconds. |
1583856000000 |
| ProductCode |
string |
No |
The name of the Alibaba Cloud service to which the data asset belongs. Valid values include MaxCompute, OSS, ADS, OTS, and RDS. |
RDS |
| ProductId |
integer |
No |
The ID of the Alibaba Cloud service to which the data object belongs. Valid values:
|
5 |
| SqlText |
string |
No |
The content of the SQL statement. |
select * from test03 |
| ExecuteTimeRange |
string |
No |
The range of the running time. |
in[1000 2000] |
| EffectRowRange |
string |
No |
The range of the number of affected rows. |
in[1 33] |
| RuleID |
string |
No |
The ID of the audit policy. |
994007 |
| RuleName |
string |
No |
The name of the audit policy. |
test_rule |
| OperateType |
string |
No |
The operation type. |
Insert |
| OssObjectKey |
string |
No |
The key of the OSS object. |
oss-key |
| AsyncRequestId |
string |
No |
The request ID. |
CE4681BA-8019-5BE1-9F4B-8973BEA9CF57 |
| PageSize |
integer |
No |
The number of entries to return on each page for a paged query. Maximum value: 50. Default value: 10. |
10 |
| CurrentPage |
integer |
No |
The page number of the paged query. Default value: 1. |
1 |
| RuleCategory |
string |
No |
The rule type. |
10 |
| LoadWhiteList |
boolean |
No |
Specifies whether to load the whitelist status. |
false |
| MemberAccount |
string |
No |
The UID of the member account. |
**********8103 |
| IpType |
string |
No |
The network type. This is an enumeration. Valid values:
|
aliyun |
| LogQueryOpJson |
string |
No |
[ { "isContain" : false, "queryKey" : "effectRowRange" }, { "isContain" : false, "queryKey" : "remoteClientIp" } ] |
|
| Message |
string |
No |
The content of the message. |
success |
| LogSource |
string |
No |
SLOW_SQL |
|
| RuleAggQuery |
boolean |
No |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
|||
| AsyncRequestId |
string |
The request ID. |
CE4681BA-8019-5BE1-9F4B-8973BEA9CF57 |
| CurrentPage |
integer |
The page number of the paged query. Default value: 1. |
1 |
| PageSize |
integer |
The number of entries returned on each page for a paged query. Maximum value: 50. Default value: 10. |
10 |
| RequestId |
string |
The ID of the request. |
A7021857-AFD9-5AD6-979D-AA7DFC5AFADF |
| TotalCount |
integer |
The total number of entries in the result set. |
12 |
| Items |
array<object> |
The list of alert logs. |
|
|
object |
The list of alert logs. |
||
| CreationTime |
integer |
The time when the alert was generated. This value is a UNIX timestamp in milliseconds. |
1536751124000 |
| WarnLevel |
string |
The risk level.
|
2 |
| ClientPort |
string |
The client port. |
35756 |
| TableName |
string |
The name of the table. |
it_table |
| EffectRow |
integer |
The number of affected rows. |
10 |
| PackageName |
string |
The name of the MaxCompute package. |
test01 |
| UserId |
string |
The UID of the user. |
19********94 |
| Message |
string |
The content of the raw log. |
success |
| RuleId |
string |
The ID of the audit policy. |
9952275 |
| OperateType |
string |
The operation type. |
Drop |
| LogTime |
integer |
The time when the log was generated. |
1751870592000 |
| WarnLevelName |
string |
The name of the risk level.
|
高危 |
| InstanceName |
string |
The name of the data asset instance. |
rm-1234 |
| DatabaseName |
string |
The name of the database. |
chngc_b2b_migration_sh |
| OssObjectKey |
string |
The key of the OSS object. |
oss-key1 |
| ExecuteStatus |
integer |
The execution status. A value of 0 indicates failure and a value of 1 indicates success. |
1 |
| ProductId |
integer |
The ID of the Alibaba Cloud service to which the data asset belongs. Valid values:
|
5 |
| ExecuteTime |
integer |
The running time in milliseconds. |
1751870592000 |
| UserName |
string |
The username. |
admin |
| InstanceDescription |
string |
The description of the data asset instance. |
instance dscription |
| RuleName |
string |
The name of the audit policy. |
name |
| ColumnName |
string |
The name of the column. |
hide14 |
| ClientIp |
string |
The IP address of the client. |
139.*.*.57 |
| ClientUa |
string |
The client type. |
mysql |
| ProductCode |
string |
The name of the Alibaba Cloud service to which the column data in the data asset table belongs. Valid values include MaxCompute, OSS, ADS, OTS, and RDS. |
RDS |
| SqlText |
string |
The SQL statement in the alert log. |
select * from test03 |
| InWhiteList |
boolean |
Indicates whether the entry is in the whitelist. |
true |
| MemberAccount |
string |
The UID of the member account. |
**********8103 |
| RuleCategory |
string |
The rule type. |
10 |
| IpType |
string |
The network type. This is an enumeration. Valid values: default (default value): a service that is not an Alibaba Cloud service aliyun: an Alibaba Cloud service |
aliyun |
| ModelName |
string |
The sensitive data model that was hit. |
Identity Card |
| DataSet |
string |
The SQL result set. |
plan_id ~ application_id ~ plan_type ~ plan_name ~ plan_value_id |
| LogSource |
string |
SLOW_SQL |
|
| InstanceAuditStatus |
string |
2 |
|
| DbType |
string |
The database type. |
MySQL |
Examples
Success response
JSON format
{
"AsyncRequestId": "CE4681BA-8019-5BE1-9F4B-8973BEA9CF57\n",
"CurrentPage": 1,
"PageSize": 10,
"RequestId": "A7021857-AFD9-5AD6-979D-AA7DFC5AFADF",
"TotalCount": 12,
"Items": [
{
"CreationTime": 1536751124000,
"WarnLevel": "2",
"ClientPort": "35756",
"TableName": "it_table",
"EffectRow": 10,
"PackageName": "test01",
"UserId": "19********94",
"Message": "success",
"RuleId": "9952275",
"OperateType": "Drop",
"LogTime": 1751870592000,
"WarnLevelName": "高危",
"InstanceName": "rm-1234",
"DatabaseName": "chngc_b2b_migration_sh",
"OssObjectKey": "oss-key1",
"ExecuteStatus": 1,
"ProductId": 5,
"ExecuteTime": 1751870592000,
"UserName": "admin",
"InstanceDescription": "instance dscription",
"RuleName": "name",
"ColumnName": "hide14",
"ClientIp": "139.*.*.57",
"ClientUa": "mysql",
"ProductCode": "RDS",
"SqlText": "select * from test03\n",
"InWhiteList": true,
"MemberAccount": "**********8103",
"RuleCategory": "10",
"IpType": "aliyun",
"ModelName": "Identity Card",
"DataSet": "plan_id ~ application_id ~ plan_type ~ plan_name ~ plan_value_id",
"LogSource": "SLOW_SQL",
"InstanceAuditStatus": "2",
"DbType": "MySQL"
}
]
}
Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.