turbot/alicloud_insights

Query: ecs_snapshot_source_disk

Usage

powerpipe query alicloud_insights.query.ecs_snapshot_source_disk

SQL

select
d.disk_id as "Disk ID",
d.name as "Name",
d.arn as "Disk ARN",
s.source_disk_size as "Disk Size (GiB)",
s.source_disk_type as "Disk Type",
d.status as "Disk Status"
from
alicloud_ecs_snapshot as s
join alicloud_ecs_disk as d on s.source_disk_id = d.disk_id
where
s.arn = $1
and s.account_id = split_part($1, ':', 5)
and s.region = split_part($1, ':', 4)
order by
d.disk_id;

Dashboards

The query is used in the dashboards: