turbot/aws_insights

Query: ecs_task_definitions_for_ecs_service

Usage

powerpipe query aws_insights.query.ecs_task_definitions_for_ecs_service

SQL

select
d.task_definition_arn as task_definition_arn
from
aws_ecs_task_definition as d,
aws_ecs_service as s
where
d.task_definition_arn = s.task_definition
and s.arn = $1
and s.account_id = split_part($1, ':', 5)
and s.region = split_part($1, ':', 4);