turbot/aws_insights

Query: elasticache_cluster_node_by_automatic_backup_status

Usage

powerpipe query aws_insights.query.elasticache_cluster_node_by_automatic_backup_status

Steampipe Tables

SQL

select
automatic_backup_status,
count(*)
from (
select snapshot_retention_limit,
case when snapshot_retention_limit is not null then
'enabled'
else
'disabled'
end automatic_backup_status
from
aws_elasticache_cluster) as a
group by
automatic_backup_status
order by
automatic_backup_status desc;

Dashboards

The query is used in the dashboards: