字段的访问历史记录

简要描述
  • 字段的访问历史记录
请求URL
  • http://xx.com/visitLog/getVisitLogDetailByColumn
请求方式
  • POST
参数
参数名 必选 类型 说明
currentPage string 第几页
pageSize string 每页几条
conditions string 查询条件,嵌套一层json。conditions:{“proxyServerId”:”226”,”columnsInSql”:”ghca31.t_base_user.tid”}
返回示例
{
    "total": 2,
    "flag": true,
    "data": [
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:24:07",
            "firstAccessDate": null,
            "number": 0,
            "proxyIp": null,
            "proxyPort": null,
            "status": "ERROR",
            "accessSqlType": "SELECT",
            "accessClient": "navicat",
            "accessIp": "192.168.2.223",
            "accessMac": "18-CC-18-8A-E5-B2",
            "impactAction": "错误",
            "tableNamesFamily": null,
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": "ghca31.t_base_user.tid",
            "proxyServerId": null
        },
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:16:51",
            "firstAccessDate": null,
            "number": 0,
            "proxyIp": null,
            "proxyPort": null,
            "status": "SUCCESS",
            "accessSqlType": "SELECT",
            "accessClient": "navicat",
            "accessIp": "192.168.2.223",
            "accessMac": "18-CC-18-8A-E5-B2",
            "impactAction": "错误",
            "tableNamesFamily": null,
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": "ghca31.t_base_user.tid",
            "proxyServerId": null
        }
    ]
}
返回参数说明
参数名 类型 说明
flag boolean 状态
total int 数据总条数
columnsInSql string 字段名
accessDate string 访问时间
accessSqlType string 语句类型
accessClient string 访问工具
accessIp string 访问者IP
accessMac string 访问者MAC
impactAction string 响应动作
status string 执行状态
备注
  • 更多返回错误代码请看首页的错误代码描述