Query: elasticache_cluster_node_by_encryption_at_transit_status

select
  encryption_status,
  count(*)
from
  (
    select
      transit_encryption_enabled,
      case
        when transit_encryption_enabled then 'enabled'
        else 'disabled'
      end encryption_status
    from
      aws_elasticache_cluster
  ) as t
group by
  encryption_status
order by
  encryption_status desc;