Skip to main content

操作审计列表

操作审计列表​

接口描述​
  • 通过该接口获取系统中操作审计列表
请求URL​
  • http://host/bbm/v2/adapter/bomber/activity/list
请求方式​
  • ==GET==
header 请求头参数​
参数名必选类型说明示例值及参考API
content-type是stringapplication/json
Authorization是string签名描述Bearer + 登录token
请求参数​
参数名必选类型说明示例值及参考API
operator_id否string操作人
db_id否int数据库id
starts_at否int开始时间
ends_at否int结束时间
limt否int返回个数 默认10个
请求示例​
http://host/bbm/v2/adapter/bomber/activity/list?limit=10

请求参数示例​

返回参数说明​

  • http_status && status_code 为200 为成功
  • 否则均为失败或者异常
字段字段示例字段说明是否必填
id1主键id否
db_id数据id否
db_type数据库类型否
db_name_info数据库名称否
operator_id操作人id否
operator_name操作人名称否
ip操作人名称否
operate_type语句类型 DDL/DCL/DQL/DML等否
content内容否
risk_status风险sql状态否
risk_sql_rules风险sql审核的内容否
status状态否
sql_duration执行时间否
starts_at开始时间否
ends_at结束时间否
review_user双人复合人ID否
review_user_name双人复合人名称否
output输出内容否
返回示例​
{
	"status_code": 200,
	"code": "",
	"message": "",
	"detail": "",
	"alert": "",
	"to_wiki": "",
	"data": [
		{
			"id": 5179410,
			"db_type": "oceanbase",
			"db_id": 1827,
			"db_name_info": "ob-mysql1(root@mysqlt#obcluster@192.168.5.11:2883/mysql)",
			"operator_id": 46718,
			"operator_name": "zy",
			"ip": "127.0.0.1",
			"operate_type": "DQL",
			"content": "select * from `test`.`duolie`",
			"risk_status": "continue",
			"risk_sql_rules": [],
			"status": "completed",
			"sql_duration": "4ms",
			"starts_at": 1730601665,
			"ends_at": 1730601666,
			"review_user": 0,
			"review_user_name": "",
			"output": "查询返回5条数据"
		},
		{
			"id": 5179409,
			"db_type": "oceanbase",
			"db_id": 1827,
			"db_name_info": "ob-mysql1(root@mysqlt#obcluster@192.168.5.11:2883/mysql)",
			"operator_id": 46718,
			"operator_name": "zy",
			"ip": "127.0.0.1",
			"operate_type": "DQL",
			"content": "select * from `test`.`duolie`",
			"risk_status": "continue",
			"risk_sql_rules": [],
			"status": "completed",
			"sql_duration": "6ms",
			"starts_at": 1730601442,
			"ends_at": 1730601442,
			"review_user": 0,
			"review_user_name": "",
			"output": "查询返回5条数据"
		}
	]
}