turbot/aws_insights

Query: ecs_cluster_container_instances

Usage

powerpipe query aws_insights.query.ecs_cluster_container_instances

SQL

select
c.ec2_instance_id as "EC2 Instance ID",
c.registered_at as "Rgeistered At",
c.arn as "ARN",
i.arn as "Instance ARN"
from
aws_ecs_container_instance as c
left join aws_ec2_instance as i on c.ec2_instance_id = i.instance_id
where
cluster_arn = $1
and c.account_id = split_part($1, ':', 5)
and c.region = split_part($1, ':', 4)
order by
ec2_instance_id;

Dashboards

The query is used in the dashboards: