turbot/steampipe-mod-aws-compliance

Control: WAF web ACL should be associated with an Application Load Balancer, API Gateway stage, or CloudFront distributions

Description

This control checks if the web ACL is associated with an Application Load Balancer, API Gateway stage, or CloudFront distributions.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.waf_web_acl_resource_associated

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_compliance.control.waf_web_acl_resource_associated --share

SQL

This control uses a named query:

select
arn as resource,
case
when jsonb_array_length(resources) > 0 then 'ok'
else 'alarm'
end as status,
case
when jsonb_array_length(resources) > 0 then title || ' associated with ' || jsonb_array_length(resources) || ' AWS resource(s).'
else title || ' not assoicated with AWS resource.'
end as reason
, region, account_id
from
aws_wafregional_web_acl;

Tags