turbot/aws_insights

Query: cloudfront_distribution_waf_status

Usage

powerpipe query aws_insights.query.cloudfront_distribution_waf_status

SQL

select
case
when web_acl_id = '' then 'disabled'
else 'enabled'
end as waf_status,
count(*)
from
aws_cloudfront_distribution
group by
waf_status
order by
waf_status;

Dashboards

The query is used in the dashboards: