turbot/aws_insights

Query: s3_bucket_logging_status

Usage

powerpipe query aws_insights.query.s3_bucket_logging_status

Steampipe Tables

SQL

with logging_status as (
select
case when logging -> 'TargetBucket' is not null then 'enabled' else 'disabled'
end as visibility
from
aws_s3_bucket
)
select
visibility,
count(*)
from
logging_status
group by
visibility;

Dashboards

The query is used in the dashboards: