Query: ecs_disk_auto_snapshot_deletion

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;