turbot/aws_insights

Query: ecs_container_instances_for_ecs_cluster

Usage

powerpipe query aws_insights.query.ecs_container_instances_for_ecs_cluster

SQL

select
i.arn as container_instance_arn
from
aws_ecs_container_instance as i
left join aws_ec2_instance as e on i.ec2_instance_id = e.instance_id
where
i.arn is not null
and i.cluster_arn = $1
and i.account_id = split_part($1, ':', 5)
and i.region = split_part($1, ':', 4);