Query: docker_info_swarm_node_cert_expiry_set

select
  id as resource,
  case
    when swarm -> 'Cluster' -> 'Spec' -> 'CaConfig' ->> 'NodeCertExpiry' is null then 'alarm'
    else 'ok'
  end as status,
  case
    when swarm -> 'Cluster' -> 'Spec' -> 'CaConfig' ->> 'NodeCertExpiry' is null then name || ' node cert expiry not set.'
    else name || ' node cert expiry set.'
  end as reason
  , _ctx ->> 'connection_name' as connection_name
from
  docker_info;