turbot/aws_insights

Query: ecs_clusters_for_ec2_instance

Usage

powerpipe query aws_insights.query.ecs_clusters_for_ec2_instance

SQL

select
distinct cluster.cluster_arn as cluster_arn
from
aws_ec2_instance as i,
aws_ecs_container_instance as ci,
aws_ecs_cluster as cluster
where
ci.ec2_instance_id = i.instance_id
and ci.cluster_arn = cluster.cluster_arn
and i.arn = $1;