turbot/aws_insights

Query: ec2_network_load_balancer_attributes

Usage

powerpipe query aws_insights.query.ec2_network_load_balancer_attributes

SQL

select
lb ->> 'Key' as "Key",
lb ->> 'Value' as "Value"
from
aws_ec2_network_load_balancer
cross join jsonb_array_elements(load_balancer_attributes) as lb
where
aws_ec2_network_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: