Query: deployment_host_table

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