turbot/aws_compliance

Query: elb_application_lb_deletion_protection_enabled

Usage

powerpipe query aws_compliance.query.elb_application_lb_deletion_protection_enabled

SQL

select
arn as resource,
case
when load_balancer_attributes @> '[{"Key": "deletion_protection.enabled", "Value": "true"}]' then 'ok'
else 'alarm'
end as status,
case
when load_balancer_attributes @> '[{"Key": "deletion_protection.enabled", "Value": "true"}]' then title || ' deletion protection enabled.'
else title || ' deletion protection disabled.'
end as reason,
region,
account_id
from
aws_ec2_application_load_balancer;

Controls

The query is being used by the following controls: