turbot/alicloud_insights

Query: ecs_snapshot_storage_by_account

Usage

powerpipe query alicloud_insights.query.ecs_snapshot_storage_by_account

SQL

select
a.title as "Account",
sum(CAST (s.source_disk_size AS INTEGER)) as "GB"
from
alicloud_ecs_snapshot as s,
alicloud_account as a
where
a.account_id = s.account_id
group by
a.title
order by
a.title;

Dashboards

The query is used in the dashboards: