turbot/aws_insights

Query: ec2_classic_load_balancer_tags

Usage

powerpipe query aws_insights.query.ec2_classic_load_balancer_tags

SQL

select
tag ->> 'Key' as "Key",
tag ->> 'Value' as "Value"
from
aws_ec2_classic_load_balancer,
jsonb_array_elements(tags_src) as tag
where
arn = $1
order by
tag ->> 'Key';

Dashboards

The query is used in the dashboards: