turbot/aws_insights

Query: kms_keys_for_elasticache_cluster_node

Usage

powerpipe query aws_insights.query.kms_keys_for_elasticache_cluster_node

SQL

select
kms_key_id as kms_key_arn
from
aws_elasticache_cluster as c,
aws_elasticache_replication_group as g
where
c.arn = $1
and c.account_id = split_part($1, ':', 5)
and c.region = split_part($1, ':', 4)
and c.replication_group_id = g.replication_group_id
and kms_key_id is not null;