Query: blockstorage_block_volume_cmk_encryption_enabled

select
  v.id as resource,
  case
    when kms_key_id is not null
    and kms_key_id <> '' then 'ok'
    else 'alarm'
  end as status,
  case
    when kms_key_id is not null
    and kms_key_id <> '' then v.title || ' encrypted with CMK.'
    else v.title || ' not encrypted with CMK.'
  end as reason,
  v.region as region,
  v.tenant_name as tenant,
  coalesce(c.name, 'root') as compartment
from
  oci_core_volume as v
  left join oci_identity_compartment as c on c.id = v.compartment_id;