turbot/aws_insights

Query: vpc_vpcs_for_elasticache_cluster_node

Usage

powerpipe query aws_insights.query.vpc_vpcs_for_elasticache_cluster_node

SQL

select
vpc_id as vpc_vpc_id
from
aws_vpc
where
vpc_id in
(
select
vpc_id
from
aws_elasticache_cluster as c,
aws_elasticache_subnet_group as g
where
g.cache_subnet_group_name = c.cache_subnet_group_name
and g.region = c.region
and c.arn = $1
and c.account_id = split_part($1, ':', 5)
);