Query: endpoint_api_serve_on_secure_port

select
  coalesce(uid, concat(path, ':', start_line)) as resource,
  case
    when p ->> 'name' = 'https' and (p ->> 'port' = '443' or p ->> 'port' = '6443') then 'ok'
    else 'alarm'
  end as status,
  case
    when p ->> 'name' = 'https' and (p ->> 'port' = '443' or p ->> 'port' = '6443') then name || ' Kubernetes API serving on secure port.'
    else name || ' Kubernetes API not serving on secure port.'
  end as reason,
  name as endpoint_name
  
  , coalesce(context_name, '') as context_name, namespace, source_type, coalesce(path || ':' || start_line || '-' || end_line, '') as path
from
  kubernetes_endpoint,
  jsonb_array_elements(subsets) as s,
  jsonb_array_elements(s -> 'ports') as p
  where name = 'kubernetes';