You need to enable JavaScript to run this app.
文档中心
数据库工作台

数据库工作台

复制全文
下载 pdf
审计日志管理
DescribeAuditLogDetail
复制全文
下载 pdf
DescribeAuditLogDetail
调用 DescribeAuditLogDetail 接口查询审计日志的详细信息。​
请求类型​
同步请求。​
请求参数​
​
参数​
类型​
是否必选​
示例值​
描述​
RegionId​
String​
是​
cn-beijing​
地域 ID。​
InstanceId​
String​
是​
mysql-71dffd******​
​
实例 ID。​
说明​
InstanceType​
String​
是​
MySQL​
数据库类型,当前仅支持取值:​
  • MySQL:表示云数据库 MySQL 版。​
  • VeDBMySQL:表示云数据库 veDB MySQL 版。​
  • Postgres:表示云数据库 PostgreSQL 版。​
  • Redis:表示缓存数据库 Redis 版。​
StartTime​
Integer​
是​
1782111588​
查询数据库审计日志的开始时间,使用秒时间戳格式。​
EndTime​
Integer​
是​
1782197988​
查询数据库审计日志的结束时间,使用秒时间戳格式。​
LogVersion​
String​
​
否​
V2​
数据库审计日志的版本,取值包括 V1(默认值)、V2。​
在调用 MySQL、VeDB MySQL 和 PostgreSQL 实例的数据库审计时,该参数的取值支持 V2。​
SearchParam​
否​
​
​
{​
"DisplaySqlTemplate": true,​
"NodeId": "mysql-06c387******-m8353-0"​
}​
​
数据库审计日志的过滤条件。​
MaxResults​
Integer​
否​
10​
分页大小,默认值为 10。​
NextToken​
String​
否​
885000,1782144054187,1125899906842923,17723951​
翻页游标,透传给下游明细查询。​
​
返回参数​
​
参数​
类型​
示例值​
描述​
DescribeAuditLogDetailRows​
​
​
[​
{​
"AffectRow": 0,​
"DB": "-",​
"Duration": 77,​
"ExecTime": 1782200733,​
"LogLevel": "",​
"LogType": "",​
"NodeId": "mysql-06c387******-m8353-0",​
"OriSql": "",​
"ReturnRows": 0,​
"ScanRows": 0,​
"SessionId": "860422",​
"SourceIP": "100.67.229.221",​
"SqlFingerprint": "d41d8cd98f00b204e9800998ecf******",​
"SqlMethod": "Connect",​
"Table": "-",​
"User": "-"​
}​
]​
​
​
数据库审计日志的明细列表。​
​
TotalCount​
Integer​
1​
数据库审计日志在指定时间内查询到的总数。​
NextToken​
String​
885000,1782144054187,1125899906842923,17723951​
翻页游标;当没有下一页时可能为空字符串或缺省。​
​
请求示例​
​
POST /?Action=DescribeAuditLogDetail&Version=2018-01-01 HTTP/1.1​
Host: /​
Content-Type: application/json; charset=UTF-8​
X-Date: 20250626T033433Z​
X-Content-Sha256: 287e874e******d653b44d21e​
Authorization: HMAC-SHA256 Credential=Adfks******wekfwe/20250626/cn-beijing/dbw/request, SignedHeaders=host;x-content-sha256;x-date, Signature=47a7d934ff7b37c03938******cd7b8278a40a1057690c401e92246a0e41085f​
{​
"InstanceID": "mysql-06c387******",​
"InstanceType": "MySQL",​
"StartTime": 1782120343,​
"EndTime": 1782206743,​
"LogVersion":"V2",​
"SearchParam": {​
"DisplaySqlTemplate": true,​
"NodeId": "mysql-06c387******-m8353-0"​
},​
"RegionId": "cn-beijing"​
}​
​
返回示例​
​
{​
"ResponseMetadata": {​
"RequestId": "2026062317273102F819CE458DA1050F46-dfe4e5",​
"Action": "DescribeAuditLogDetail",​
"Version": "2018-01-01",​
"Service": "dbw",​
"Region": "cn-beijing"​
},​
"Result": {​
"DescribeAuditLogDetailRows": [​
{​
"AffectRow": 0,​
"DB": "-",​
"Duration": 77,​
"ExecTime": 1782200733,​
"LogLevel": "",​
"LogType": "",​
"NodeId": "mysql-06c387******-m8353-0",​
"OriSql": "",​
"ReturnRows": 0,​
"ScanRows": 0,​
"SessionId": "860422",​
"SourceIP": "100.67.229.221",​
"SqlFingerprint": "d41d8cd98f00b204e9800998ecf******",​
"SqlMethod": "Connect",​
"Table": "-",​
"User": "-"​
}​
],​
"NextToken": "",​
"TotalCount": 1​
}​
}​
​
错误码​
更多详情,请参见错误码。​
​
最近更新时间:2026.09.01 14:01:58
这个页面对您有帮助吗?
有用
有用
无用
无用