turbot/alicloud_insights

Query: ecs_instances_for_ecs_snapshot

Usage

powerpipe query alicloud_insights.query.ecs_instances_for_ecs_snapshot

SQL

select
i.arn as instance_arn
from
alicloud_ecs_snapshot s
join alicloud_ecs_disk as d on s.source_disk_id = d.disk_id
join alicloud_ecs_instance as i on i.instance_id = d.instance_id
where
s.arn = $1
and s.account_id = split_part($1, ':', 5)
and s.region = split_part($1, ':', 4);