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;