Query: List clusters provisioned with undesired (for example, cache.m5.large and cache.m4.4xlarge are desired) node types

Description

Identify instances where clusters have been provisioned with undesired node types, enabling you to streamline your resources and align with your preferred configurations. This is particularly useful for maintaining consistency and optimizing performance across your infrastructure.

Query

Tables used in this query:

• aws_elasticache_cluster

SQL