turbot/aws_insights

Query: ec2_application_load_balancers_for_cloudfront_distribution

Usage

powerpipe query aws_insights.query.ec2_application_load_balancers_for_cloudfront_distribution

SQL

select
b.arn as alb_arn
from
aws_cloudfront_distribution as d,
jsonb_array_elements(origins) as origin
left join aws_ec2_application_load_balancer as b on b.dns_name = origin ->> 'DomainName'
where
b.arn is not null
and d.arn = $1;