turbot/oci_insights

Query: blockstorage_block_volume_encryption

Usage

powerpipe query oci_insights.query.blockstorage_block_volume_encryption

SQL

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_volume as v
left join oci_kms_key as k on v.kms_key_id = k.id
where
v.id = $1;

Dashboards

The query is used in the dashboards: