Query: blockstorage_boot_volume_encryption

select
  k.name as "Key Name",
  case when kms_key_id is not null and kms_key_id <> '' then 'Customer Managed' else 'Oracle Managed' end as "Encryption Status",
  kms_key_id as "KMS Key ID"
from
  oci_core_boot_volume as v
  left join oci_kms_key as k
  on v.kms_key_id = k.id
where
  v.id  = $1;