Query: cronjob_host_table

select
  name as "Name",
  case
    when job_template -> 'spec' -> 'template' -> 'spec' ->> 'hostNetwork' = 'true' then 'Enabled'
    else 'Disabled'
  end as "Host Network",
  case
    when job_template -> 'spec' -> 'template' -> 'spec' ->> 'hostPID' = 'true' then 'Enabled'
    else 'Disabled'
  end as "Host PID",
  case
    when job_template -> 'spec' -> 'template' -> 'spec' ->> 'hostIPC' = 'true' then 'Enabled'
    else 'Disabled'
  end as "Host IPC",
  context_name as "Context Name",
  uid as "UID"
from
  kubernetes_cronjob
order by
  name;