turbot/aws_insights

Query: ec2_classic_load_balancers_for_ec2_instance

Usage

powerpipe query aws_insights.query.ec2_classic_load_balancers_for_ec2_instance

SQL

select
distinct clb.arn as classic_load_balancer_arn
from
aws_ec2_classic_load_balancer as clb,
jsonb_array_elements(clb.instances) as instance,
aws_ec2_instance as i
where
i.arn = $1
and instance ->> 'InstanceId' = i.instance_id;