查询WAF日志 统计图表 统计图表是日志服务根据查询与分析语句渲染出的结果。 WAF日志分析提供表格、线图、柱状图等多种图表类型,具体使用方法请参考:云日志服务统计图表。 添加到仪表盘 :仪表盘是日志服务提供的实时数据分析大盘。单击添加到仪表盘 ,将查询和分析结果以图表形式保存到仪表盘中。具体操作,请参见可视化概述。 图表配置:在右侧选择需要展示的图标类型。 日志查询案例 该查询执行语句执行以后,生成的图表包含以下字段:总请求数、200比例、302比例、404比例、、499比例、500比例,分别表示域名选择时间范围内的总请求量和各类型响应状态码的占比。 图表预览: plaintext SELECT remotehost AS "域名", Rate200 AS "200比例", Rate302 AS "302比例", Rate404 AS "404比例", Rate499 AS "499比例", Rate500 AS "500比例", Rate502 AS "502比例", Rate503 AS "503比例", Rate504 AS "504比例", countall AS "总请求数", code200, code302, code404, code499, code500, code502, code503, code504 FROM( SELECT remotehost, round(round(code200 1.0000 / countall, 4) 100, 2) AS Rate200, round(round(code302 1.0000 / countall, 4) 100, 2) AS Rate302, round(round(code404 1.0000 / countall, 4) 100, 2) AS Rate404, round(round(code499 1.0000 / countall, 4) 100, 2) AS Rate499, round(round(code500 1.0000 / countall, 4) 100, 2) AS Rate500, round(round(code502 1.0000 / countall, 4) 100, 2) AS Rate502, round(round(code503 1.0000 / countall, 4) 100, 2) AS Rate503, round(round(code504 1.0000 / countall, 4) 100, 2) AS Rate504, countall, code200, code302, code404, code499, code500, code502, code503, code504 FROM ( SELECT remotehost, countif(respcode'200') AS code200, countif(respcode'302') AS code302, countif(respcode'404') AS code404, countif(respcode'499') AS code499, countif(respcode'500') AS code500, countif(respcode'502') AS code502, countif(respcode'503') AS code503, countif(respcode'504') AS code504, COUNT() AS countall FROM log WHERE isattack 'false' GROUP BY remotehost ) ) WHERE countall > 10 ORDER BY Rate200 DESC LIMIT 5