Query: blockstorage_boot_volume_by_encryption_status

select
  encryption_status,
  count(*)
from (
  select
    id,
    case
      when kms_key_id is null then 'oracle-managed'
      else 'customer-managed'
    end as encryption_status
  from
    oci_core_boot_volume
  where
    lifecycle_state <> 'TERMINATED') as v
  group by
    encryption_status
  order by
    encryption_status desc;