turbot/aws_insights

Query: ecs_tasks_for_ecs_service

Usage

powerpipe query aws_insights.query.ecs_tasks_for_ecs_service

SQL

select
t.task_arn as task_arn
from
aws_ecs_task as t,
aws_ecs_service as s
where
s.arn = $1
and s.account_id = split_part($1, ':', 5)
and s.region = split_part($1, ':', 4)
and t.service_name = s.service_name
and t.region = s.region;