turbot/aws_insights

Query: ec2_application_load_balancer_attributes

Usage

powerpipe query aws_insights.query.ec2_application_load_balancer_attributes

SQL

select
lb ->> 'Key' as "Key",
lb ->> 'Value' as "Value"
from
aws_ec2_application_load_balancer
cross join jsonb_array_elements(load_balancer_attributes) as lb
where
aws_ec2_application_load_balancer.arn = $1
and lb ->> 'Key' not in ( 'deletion_protection.enabled' ,'access_logs.s3.enabled' )
order by
lb ->> 'Key';

Dashboards

The query is used in the dashboards: