zeroTrust

零信任


字段的访问历史记录

<h5>简要描述</h5> <ul> <li>字段的访问历史记录</li> </ul> <h5>请求URL</h5> <ul> <li><code>http://xx.com/visitLog/getVisitLogDetailByColumn</code></li> </ul> <h5>请求方式</h5> <ul> <li>POST </li> </ul> <h5>参数</h5> <table> <thead> <tr> <th style="text-align: left;">参数名</th> <th style="text-align: left;">必选</th> <th style="text-align: left;">类型</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td style="text-align: left;">currentPage</td> <td style="text-align: left;">是</td> <td style="text-align: left;">string</td> <td>第几页</td> </tr> <tr> <td style="text-align: left;">pageSize</td> <td style="text-align: left;">是</td> <td style="text-align: left;">string</td> <td>每页几条</td> </tr> <tr> <td style="text-align: left;">conditions</td> <td style="text-align: left;">是</td> <td style="text-align: left;">string</td> <td>查询条件,嵌套一层json。conditions:{&quot;proxyServerId&quot;:&quot;226&quot;,&quot;columnsInSql&quot;:&quot;ghca31.t_base_user.tid&quot;}</td> </tr> </tbody> </table> <h5>返回示例</h5> <pre><code>{ "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 } ] }</code></pre> <h5>返回参数说明</h5> <table> <thead> <tr> <th style="text-align: left;">参数名</th> <th style="text-align: left;">类型</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td style="text-align: left;">flag</td> <td style="text-align: left;">boolean</td> <td>状态</td> </tr> <tr> <td style="text-align: left;">total</td> <td style="text-align: left;">int</td> <td>数据总条数</td> </tr> <tr> <td style="text-align: left;">columnsInSql</td> <td style="text-align: left;">string</td> <td>字段名</td> </tr> <tr> <td style="text-align: left;">accessDate</td> <td style="text-align: left;">string</td> <td>访问时间</td> </tr> <tr> <td style="text-align: left;">accessSqlType</td> <td style="text-align: left;">string</td> <td>语句类型</td> </tr> <tr> <td style="text-align: left;">accessClient</td> <td style="text-align: left;">string</td> <td>访问工具</td> </tr> <tr> <td style="text-align: left;">accessIp</td> <td style="text-align: left;">string</td> <td>访问者IP</td> </tr> <tr> <td style="text-align: left;">accessMac</td> <td style="text-align: left;">string</td> <td>访问者MAC</td> </tr> <tr> <td style="text-align: left;">impactAction</td> <td style="text-align: left;">string</td> <td>响应动作</td> </tr> <tr> <td style="text-align: left;">status</td> <td style="text-align: left;">string</td> <td>执行状态</td> </tr> </tbody> </table> <h5>备注</h5> <ul> <li>更多返回错误代码请看首页的错误代码描述</li> </ul>

页面列表

ITEM_HTML