turbot/aws_compliance

Query: elasticache_cluster_no_default_subnet_group

Usage

powerpipe query aws_compliance.query.elasticache_cluster_no_default_subnet_group

Steampipe Tables

SQL

select
arn as resource,
case
when cache_subnet_group_name = 'default' then 'alarm'
else 'ok'
end as status,
case
when cache_subnet_group_name = 'default' then title || ' not configured with a custom subnet group.'
else title || ' configured with a custom subnet group.'
end as reason,
region,
account_id
from
aws_elasticache_cluster;

Controls

The query is being used by the following controls: