mac地址访问历史记录

简要描述
  • mac地址访问历史记录
请求URL
  • http://xx.com/visitLog/getVisitLogDetailByAccessMac
请求方式
  • POST
参数
参数名 必选 类型 说明
currentPage string 第几页
pageSize string 每页几条
conditions string 查询条件,嵌套一层json。conditions:{“proxyServerId”:”226”,”accessMac”:”18-CC-18-8A-E5-B2”}
返回示例
{
    "total": 14,
    "flag": true,
    "data": [
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:19:46",
            "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": "ghca31.t_base_user",
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": null,
            "proxyServerId": null,
            "visitTables": null
        },
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:17:40",
            "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": "ghca31.t_base_user",
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": null,
            "proxyServerId": null,
            "visitTables": null
        },
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:23:44",
            "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": "ghca31.t_base_user",
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": null,
            "proxyServerId": null,
            "visitTables": null
        },
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:18:56",
            "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": "ghca31.t_base_user",
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": null,
            "proxyServerId": null,
            "visitTables": null
        },
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:17:50",
            "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": "ghca31.t_base_user",
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": null,
            "proxyServerId": null,
            "visitTables": null
        },
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:17:50",
            "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": "ghca31.t_base_user1",
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": null,
            "proxyServerId": null,
            "visitTables": null
        },
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:17:50",
            "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": "ghca31.t_base_user2",
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": null,
            "proxyServerId": null,
            "visitTables": null
        },
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:17:50",
            "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": "ghca31.t_base_user3",
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": null,
            "proxyServerId": null,
            "visitTables": null
        },
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:17:50",
            "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": "ghca31.t_base_user4",
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": null,
            "proxyServerId": null,
            "visitTables": null
        },
        {
            "id": null,
            "dbUser": null,
            "accessDate": "2021-10-10 18:17:50",
            "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": "ghca31.t_base_user5",
            "tableNum": 0,
            "accessOsUser": null,
            "columnsInSql": null,
            "proxyServerId": null,
            "visitTables": null
        }
    ]
}
返回参数说明
参数名 类型 说明
flag boolean 状态
total int 数据总条数
accessDate string 访问时间
accessSqlType string 语句类型
accessClient string 访问工具
accessIp string 访问者IP
accessMac string 访问者MAC
impactAction string 响应动作
status string 执行状态
备注
  • 更多返回错误代码请看首页的错误代码描述