turbot/aws_insights

Query: efs_file_system_by_automatic_backup_status

Usage

powerpipe query aws_insights.query.efs_file_system_by_automatic_backup_status

Steampipe Tables

SQL

select
automatic_backup_status,
count(*)
from (
select
case when automatic_backups = 'enabled' then 'Enabled' else 'Disabled' end automatic_backup_status
from
aws_efs_file_system
) as t
group by
automatic_backup_status
order by
automatic_backup_status;

Dashboards

The query is used in the dashboards: