{"provider_url":"https://hatena.blog","author_name":"yohei-a","type":"rich","published":"2021-07-18 13:10:48","title":"AppConfig \u3067\u6599\u91d1\u304c\u9ad8\u9a30\u3057\u305f\u5834\u5408\u306b\u3001\u547c\u3073\u51fa\u3057\u5143\u3092\u7279\u5b9a\u3059\u308b Athena \u30af\u30a8\u30ea for CloudTrail","author_url":"https://blog.hatena.ne.jp/yohei-a/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20210718%2F1626581448\" title=\"AppConfig \u3067\u6599\u91d1\u304c\u9ad8\u9a30\u3057\u305f\u5834\u5408\u306b\u3001\u547c\u3073\u51fa\u3057\u5143\u3092\u7279\u5b9a\u3059\u308b Athena \u30af\u30a8\u30ea for CloudTrail - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","provider_name":"Hatena Blog","blog_title":"ablog","blog_url":"https://yohei-a.hatenablog.jp/","url":"https://yohei-a.hatenablog.jp/entry/20210718/1626581448","categories":["AWS"],"width":"100%","description":"AppConfig \u3067\u6599\u91d1\u304c\u9ad8\u9a30\u3057\u305f\u5834\u5408\u306b\u3001\u547c\u3073\u51fa\u3057\u5143\u3092\u7279\u5b9a\u3059\u308b\u30af\u30a8\u30ea SELECT useridentity.arn AS useridentity_arn, count(*) as configurationReceived FROM cloudtrail_table WHERE eventsource = 'appconfig.amazonaws.com' AND eventname = 'GetConfiguration' AND date = '2021/06/20' -- \u78ba\u8a8d\u3057\u305f\u3044\u65e5\u4ed8\u306b\u5909\u66f4\u3059\u308b\u3053\u3068 AND CAST(json_extract_scalar(requestpara\u2026","version":"1.0","image_url":null}