Query: elasticache_cluster_node_encryption_at_transit_disabled_count

select
  count(*) as value,
  'Encryption in Transit Disabled' as label,
  case
    when count(*) > 0 then 'alert' else 'ok' end as "type"
from
  aws_elasticache_cluster
where
  not transit_encryption_enabled;