Queries the list of audit alert logs.
Operation description
This operation is used to query the list of data audit alert logs, which facilitates alerting search and alerting handling.
QPS limit
The single-user QPS limit for this operation is 10 calls per second. If the limit is exceeded, API calls are throttled, which may affect your business. Invoke this operation at an appropriate frequency.
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 request client. |
10.*.*.94 |
| ClientUa |
string |
No |
The client type. |
mysql |
| InstanceName |
string |
No |
The name of the asset instance. |
i-2zeftaaq4gqcqb9kfkzg |
| DatabaseName |
string |
No |
The database name. |
bose_o2o_data |
| StartTime |
integer |
No |
The start time of the alert log, in milliseconds. |
1616068534877 |
| EndTime |
integer |
No |
The end time of the alert log. The value is a UNIX timestamp in milliseconds. |
1583856000000 |
| ProductCode |
string |
No |
The name of the product to which the data asset belongs. Valid values: MaxCompute, OSS, ADS, OTS, RDS, and more. |
RDS |
| ProductId |
integer |
No |
The ID that corresponds to the product name 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 execution time. |
in[1000 2000] |
| EffectRowRange |
string |
No |
The range of affected rows. |
in[1 33] |
| 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 per page in a paged query. Maximum value: 50. Default value: 10. |
10 |
| CurrentPage |
integer |
No |
The page number in a 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 accounts. |
**********8103 |
| IpType |
string |
No |
The network type. Valid values:
|
aliyun |
| LogQueryOpJson |
string |
No |
The JSON string that specifies whether the query conditions are included. |
[ { "isContain" : false, "queryKey" : "effectRowRange" }, { "isContain" : false, "queryKey" : "remoteClientIp" } ] |
| Message |
string |
No |
The message content. |
success |
| LogSource |
string |
No |
The data source. |
SLOW_SQL |
| RuleAggQuery |
boolean |
No |
Specifies whether to perform an aggregate query. |
true |
| RuleId |
string |
No |
The ID of the audit policy. |
867028 |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
|||
| AsyncRequestId |
string |
The request ID. |
CE4681BA-8019-5BE1-9F4B-8973BEA9CF57 |
| CurrentPage |
integer |
The page number in a paged query. Default value: 1. |
1 |
| PageSize |
integer |
The number of entries per page in a paged query. Maximum value: 50. Default value: 10. |
10 |
| RequestId |
string |
The request ID. |
A7021857-AFD9-5AD6-979D-AA7DFC5AFADF |
| TotalCount |
integer |
The total number of entries returned. |
12 |
| Items |
array<object> |
The list of alert logs. |
|
|
object |
The list of alert logs. |
||
| CreationTime |
integer |
The alert time, in milliseconds. |
1536751124000 |
| WarnLevel |
string |
The risk level. Valid values:
|
2 |
| ClientPort |
string |
The client port. |
35756 |
| TableName |
string |
The table name. |
it_table |
| EffectRow |
integer |
The number of affected rows. |
10 |
| PackageName |
string |
The MaxCompute package name. |
test01 |
| UserId |
string |
The user UID. |
19********94 |
| Message |
string |
The raw log content. |
success |
| RuleId |
string |
The audit policy ID. |
9952275 |
| OperateType |
string |
The operation type. |
Drop |
| LogTime |
integer |
The log execution time. |
1751870592000 |
| WarnLevelName |
string |
The name of the risk level. Valid values:
|
High risk |
| InstanceName |
string |
The name of the asset instance. |
rm-1234 |
| DatabaseName |
string |
The database name. |
chngc_b2b_migration_sh |
| OssObjectKey |
string |
The key of the OSS object. |
oss-key1 |
| ExecuteStatus |
integer |
The execution status. Valid values:
|
1 |
| ProductId |
integer |
The ID that corresponds to the product name to which the data asset belongs. Valid values:
|
5 |
| ExecuteTime |
integer |
The execution duration, 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 column name. |
hide14 |
| ClientIp |
string |
The client IP address. |
139.*.*.57 |
| ClientUa |
string |
The client type. |
mysql |
| ProductCode |
string |
The name of the product to which the column data in the data asset table belongs. Valid values: MaxCompute, OSS, ADS, OTS, RDS, and more. |
RDS |
| SqlText |
string |
The SQL statement in the alert log. |
select * from test03 |
| InWhiteList |
boolean |
Indicates whether the entry is whitelisted. |
true |
| MemberAccount |
string |
The UID of the member accounts. |
**********8103 |
| RuleCategory |
string |
The rule type. |
10 |
| IpType |
string |
The network type. Valid values: default (default): non-Alibaba Cloud service aliyun: Alibaba Cloud service |
aliyun |
| ModelName |
string |
The sensitive data model that was matched. |
Identity Card |
| DataSet |
string |
The SQL result set. |
plan_id ~ application_id ~ plan_type ~ plan_name ~ plan_value_id |
| LogSource |
string |
The data source. |
SLOW_SQL |
| InstanceAuditStatus |
string |
The instance audit status. |
2 |
| DbType |
string |
The database type. |
MySQL |
| RamConsoleLink |
string |
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": "High risk",
"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",
"RamConsoleLink": ""
}
]
}
Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.