turbot/oci_insights

Query: blockstorage_boot_volume_by_encryption_status

Usage

powerpipe query oci_insights.query.blockstorage_boot_volume_by_encryption_status

Steampipe Tables

SQL

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

Dashboards

The query is used in the dashboards: