turbot/aws_insights

Query: s3_bucket_by_default_encryption_status

Usage

powerpipe query aws_insights.query.s3_bucket_by_default_encryption_status

Steampipe Tables

SQL

with default_encryption as (
select
case when server_side_encryption_configuration is not null then 'enabled' else 'disabled'
end as visibility
from
aws_s3_bucket
)
select
visibility,
count(*)
from
default_encryption
group by
visibility;

Dashboards

The query is used in the dashboards: