Query: ibm_is_volume_encryption_report

select
  v.name as "Name",
  v.id as "ID",
  v.encryption as "Encryption Type",
  v.encryption_key as "Encryption Key",
  a.name as "Account",
  v.account_id as "Account ID",
  v.region as "Region",
  v.zone ->> 'name' as "Zone",
  v.resource_group ->> 'name' as "Resource Group",
  v.crn as "CRN"
from
  ibm_is_volume as v,
  ibm_account as a
where
  v.account_id = a.customer_id
order by
  v.name;