AWS-WAF-Log S3存放,通过Athena查看
创始人
2025-01-11 07:08:09
0次

1.创建好waf-cdn 并且设置好规则和log存储方式为s3

在这里插入图片描述

2. Amazon Athena 服务 使用 (注意s3桶位置相同得区域)

https://docs.aws.amazon.com/zh_cn/athena/latest/ug/waf-logs.html
官方文档参考,建一个分区查询表

不能直接使用 因为是cdn 资源需要修改相关字段

CREATE EXTERNAL TABLE `waf_logs`(   `timestamp` bigint,   `formatversion` int,   `webaclid` string,   `terminatingruleid` string,   `terminatingruletype` string,   `action` string,   `terminatingrulematchdetails` array <                                     struct <                                         conditiontype: string,                                         sensitivitylevel: string,                                         location: string,                                         matcheddata: array < string >                                           >                                      >,   `httpsourcename` string,   `httpsourceid` string,   `rulegrouplist` array <                       struct <                           rulegroupid: string,                           terminatingrule: struct <                                               ruleid: string,                                               action: string,                                               rulematchdetails: array <                                                                    struct <                                                                        conditiontype: string,                                                                        sensitivitylevel: string,                                                                        location: string,                                                                        matcheddata: array < string >                                                                           >                                                                     >                                                 >,                           nonterminatingmatchingrules: array <                                                               struct <                                                                   ruleid: string,                                                                   action: string,                                                                   overriddenaction: string,                                                                   rulematchdetails: array <                                                                                        struct <                                                                                            conditiontype: string,                                                                                            sensitivitylevel: string,                                                                                            location: string,                                                                                            matcheddata: array < string >                                                                                               >                                                                    >,                                                                   challengeresponse: struct <                                                                             responsecode: string,                                                                             solvetimestamp: string                                                                               >,                                                                   captcharesponse: struct <                                                                             responsecode: string,                                                                             solvetimestamp: string                                                                               >                                                                     >                                                              >,                           excludedrules: string                             >                        >, `ratebasedrulelist` array <                          struct <                              ratebasedruleid: string,                              limitkey: string,                              maxrateallowed: int                                >                           >,   `nonterminatingmatchingrules` array <                                     struct <                                         ruleid: string,                                         action: string,                                         rulematchdetails: array <                                                              struct <                                                                  conditiontype: string,                                                                  sensitivitylevel: string,                                                                  location: string,                                                                  matcheddata: array < string >                                                                     >                                                              >,                                         challengeresponse: struct <                                                             responsecode: string,                                                             solvetimestamp: string                                                              >,                                         captcharesponse: struct <                                                             responsecode: string,                                                             solvetimestamp: string                                                              >                                           >                                      >,   `requestheadersinserted` array <                                 struct <                                     name: string,                                     value: string                                       >                                  >,   `responsecodesent` string,   `httprequest` struct <                     clientip: string,                     country: string,                     headers: array <                                 struct <                                     name: string,                                     value: string                                       >                                  >,                     uri: string,                     args: string,                     httpversion: string,                     httpmethod: string,                     requestid: string                       >,   `labels` array <                struct <                    name: string                      >                 >,   `captcharesponse` struct <                         responsecode: string,                         solvetimestamp: string,                         failureReason: string                           >,   `challengeresponse` struct <                         responsecode: string,                         solvetimestamp: string,                         failureReason: string                         >,   `ja3Fingerprint` string,   `oversizefields` string,   `requestbodysize` int,   `requestbodysizeinspectedbywaf` int ) PARTITIONED BY (  `region` string,  `date` string)  ROW FORMAT SERDE    'org.openx.data.jsonserde.JsonSerDe'  STORED AS INPUTFORMAT    'org.apache.hadoop.mapred.TextInputFormat'  OUTPUTFORMAT    'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION   's3:///AWSLogs//WAFLogs/cloudfront/' TBLPROPERTIES(  'projection.enabled' = 'true',  'projection.region.type' = 'enum',  'projection.region.values' = 'cloudfront',  'projection.date.type' = 'date',  'projection.date.range' = '2024/07/08,NOW',  'projection.date.format' = 'yyyy/MM/dd',  'projection.date.interval' = '1',  'projection.date.interval.unit' = 'DAYS',  'storage.location.template' = 's3:///AWSLogs//WAFLogs/${region}//${date}/') 

修改< >中的字符为自己的资源

测试查询

SELECT    COUNT(httpRequest.country) as count,    httpRequest.country  FROM waf_logs WHERE    terminatingruletype='RATE_BASED'  GROUP BY httpRequest.country ORDER BY count LIMIT 100; 
SELECT    COUNT(*) AS count,   webaclid,   action,   httprequest.clientip,   httprequest.uri FROM waf_logs WHERE terminatingruleid='' GROUP BY webaclid, action, httprequest.clientip, httprequest.uri ORDER BY count DESC LIMIT 100; 

具体的sql 字段需要修改成自己的 可以先检索全表 查看字段 方便搜索
在这里插入图片描述

相关内容

热门资讯

推荐一款透视器!葫芦娃大厅透视... 推荐一款透视器!葫芦娃大厅透视器多功能AIapp,葫芦娃大厅果然是有透视器app1.葫芦娃大厅 选牌...
一分钟了解透视挂!东游大厅透视... 一分钟了解透视挂!东游大厅透视挂多功能AI脚本,东游大厅都是存在有透视挂脚本1、下载好东游大厅正确养...
我来向大家传授外挂!孔雀互娱外... 我来向大家传授外挂!孔雀互娱外挂多功能AI插件,孔雀互娱真是是真的有外挂插件1、完成孔雀互娱有辅助插...
我来教大家透视器!青岛大厅透视... 我来教大家透视器!青岛大厅透视器多功能AI插件,青岛大厅其实是有透视器插件1、青岛大厅免费辅助多个强...
一分钟带你了解辅助!067互娱... 一分钟带你了解辅助!067互娱辅助多功能AI教程,067互娱其实有辅助教程1、任何067互娱透视是真...
技术分享辅助!起点大厅辅助多功... 技术分享辅助!起点大厅辅助多功能AI技巧,起点大厅果然是有辅助技巧1、起透看视 起点大厅辅助软件价格...
一分钟教会你外挂!新玄龙外挂多... 一分钟教会你外挂!新玄龙外挂多功能AI插件,新玄龙真是是有外挂插件1、游戏颠覆性的策略玩法,独创攻略...
一分钟了解辅助!东游大厅辅助多... 一分钟了解辅助!东游大厅辅助多功能AI脚本,东游大厅总是有辅助脚本1、东游大厅透视辅助软件激活码多个...
我来教教你辅助!卡米大厅辅助多... 我来教教你辅助!卡米大厅辅助多功能AI方法,卡米大厅切实真的有辅助方法1、实时卡米大厅透视辅助更新:...
玩家必备教程辅助!辣椒大厅辅助... 玩家必备教程辅助!辣椒大厅辅助多功能AI软件,辣椒大厅原来真的有辅助软件1、许多玩家不知道辣椒大厅辅...