Query: redis_cache_min_tls_1_2

select
  c.id as resource,
  case
    when minimum_tls_version is null then 'alarm'
    when minimum_tls_version = '1.2' then 'ok'
    else 'alarm'
  end as status,
  case
    when minimum_tls_version is null then c.name || ' minimum TLS version not set.'
    else c.name || ' minimum TLS version set to ' || minimum_tls_version || '.'
  end as reason,
  c.resource_group as resource_group,
  sub.display_name as subscription
from
  azure_redis_cache as c,
  azure_subscription sub
where
  sub.subscription_id = c.subscription_id;