turbot/aws_insights

Query: s3_bucket_versioning_mfa_status

Usage

powerpipe query aws_insights.query.s3_bucket_versioning_mfa_status

Steampipe Tables

SQL

with versioning_mfa_status as (
select
case
when versioning_mfa_delete then 'enabled' else 'disabled'
end as visibility
from
aws_s3_bucket
)
select
visibility,
count(*)
from
versioning_mfa_status
group by
visibility;

Dashboards

The query is used in the dashboards: