Query: blockstorage_block_volume_with_backups

select
  case when volume_backup_policy_assignment_id is null then 'no backup policy' else 'with backup policy' end as status,
  count(*)
from
  oci_core_volume
where
  lifecycle_state <> 'TERMINATED'
group by
  status;