turbot/oci_insights

Query: blockstorage_block_volume_storage_by_encryption_type

Usage

powerpipe query oci_insights.query.blockstorage_block_volume_storage_by_encryption_type

Steampipe Tables

SQL

select
case
when kms_key_id is null then 'oracle-managed'
else 'customer-managed'
end as encryption_type,
sum(size_in_gbs) as "GB"
from
oci_core_volume
where
lifecycle_state <> 'TERMINATED'
group by
encryption_type;

Dashboards

The query is used in the dashboards: