Query: cloudfront_distribution_waf_disabled

select
  'WAF Disabled' as label,
  count(*) as value,
  case
    count(*)
    when 0 then 'ok'
    else 'alert'
  end as type
from
  aws_cloudfront_distribution
where
  web_acl_id = '';