turbot/oci_insights

Query: blockstorage_block_volume_by_encryption_type

Usage

powerpipe query oci_insights.query.blockstorage_block_volume_by_encryption_type

Steampipe Tables

SQL

select
encryption_type,
count(*)
from
(
select
id,
case
when kms_key_id is null then 'oracle-managed'
else 'customer-managed'
end as encryption_type
from
oci_core_volume
where
lifecycle_state <> 'TERMINATED'
) as v
group by
encryption_type
order by
encryption_type desc;

Dashboards

The query is used in the dashboards: