turbot/oci_compliance

Query: blockstorage_block_volume_cmk_encryption_enabled

Usage

powerpipe query oci_compliance.query.blockstorage_block_volume_cmk_encryption_enabled

SQL

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;

Controls

The query is being used by the following controls: