turbot/alicloud_insights

Query: ecs_snapshots_for_ecs_instance

Usage

powerpipe query alicloud_insights.query.ecs_snapshots_for_ecs_instance

SQL

select
s.arn as snapshot_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
i.account_id = split_part($1, ':', 5)
and i.region = split_part($1, ':', 4)
and i.arn = $1;