turbot/aws_insights

Query: vpc_subnets_for_ecs_cluster

Usage

powerpipe query aws_insights.query.vpc_subnets_for_ecs_cluster

SQL

select
s.subnet_id as subnet_id
from
aws_ecs_container_instance as i
right join aws_ec2_instance as c on c.instance_id = i.ec2_instance_id
right join aws_vpc_subnet as s on s.subnet_id = c.subnet_id
where
i.cluster_arn = $1;