turbot/alicloud_insights

Query: target_ecs_disks_for_ecs_snapshot

Usage

powerpipe query alicloud_insights.query.target_ecs_disks_for_ecs_snapshot

SQL

select
d.arn as disk_arn
from
alicloud_ecs_snapshot s
left join alicloud_ecs_disk as d on s.snapshot_id = d.source_snapshot_id
where
s.arn = $1
and s.account_id = split_part($1, ':', 5)
and s.region = split_part($1, ':', 4)
and d.arn is not null;