turbot/alicloud_insights

Query: ecs_disk_auto_snapshot_deletion

Usage

powerpipe query alicloud_insights.query.ecs_disk_auto_snapshot_deletion

Steampipe Tables

SQL

select
delete_auto_snapshot_enabled,
count(*) as "Disks"
from (
select
delete_auto_snapshot,
case when delete_auto_snapshot then
'enabled'
else
'disabled'
end delete_auto_snapshot_enabled
from
alicloud_ecs_disk
where
enable_auto_snapshot) as t
group by
delete_auto_snapshot_enabled
order by
delete_auto_snapshot_enabled desc;

Dashboards

The query is used in the dashboards: