turbot/aws_insights

Query: rds_db_cluster_snapshot_by_encryption_status

Usage

powerpipe query aws_insights.query.rds_db_cluster_snapshot_by_encryption_status

SQL

select
encryption_status,
count(*)
from (
select storage_encrypted,
case when storage_encrypted then
'enabled'
else
'disabled'
end encryption_status
from
aws_rds_db_cluster_snapshot) as t
group by
encryption_status
order by
encryption_status desc;

Dashboards

The query is used in the dashboards: