turbot/aws_insights

Query: elasticache_cluster_node_notification_configuration

Usage

powerpipe query aws_insights.query.elasticache_cluster_node_notification_configuration

SQL

select
t.title as "Topic Title",
notification_configuration ->> 'TopicStatus' as "Topic Status"
from
aws_elasticache_cluster as c
left join
aws_sns_topic as t
on notification_configuration ->> 'TopicArn' = topic_arn
where
c.arn = $1
and c.account_id = split_part($1, ':', 5)
and c.region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: