turbot/alicloud_insights

Query: ecs_disk_by_status

Usage

powerpipe query alicloud_insights.query.ecs_disk_by_status

Steampipe Tables

SQL

select
usage_status,
count(*) as "Disks"
from (
select status,
case when status = 'In_use' then
'in-use'
else
'unused'
end usage_status
from
alicloud_ecs_disk) as t
group by
usage_status
order by
usage_status desc;

Dashboards

The query is used in the dashboards: