turbot/oci_insights

Query: objectstorage_bucket_public_access_status

Usage

powerpipe query oci_insights.query.objectstorage_bucket_public_access_status

Steampipe Tables

SQL

with public_access_stat as (
select
case
when public_access_type = 'NoPublicAccess' then 'disabled'
else 'enabled'
end as public_access_stat
from
oci_objectstorage_bucket
)
select
public_access_stat,
count(*)
from
public_access_stat
group by
public_access_stat

Dashboards

The query is used in the dashboards: