turbot/aws_insights

Query: s3_buckets_for_ec2_classic_load_balancer

Usage

powerpipe query aws_insights.query.s3_buckets_for_ec2_classic_load_balancer

SQL

select
b.arn as bucket_arn
from
aws_s3_bucket b,
aws_ec2_classic_load_balancer as clb
where
clb.arn = $1
and b.name = clb.access_log_s3_bucket_name;