turbot/oci_insights

Query: objectstorage_bucket_encryption_status

Usage

powerpipe query oci_insights.query.objectstorage_bucket_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_objectstorage_bucket) as b
group by
encryption_status
order by
encryption_status desc;

Dashboards

The query is used in the dashboards: