turbot/kubernetes_insights

Query: job_host_table

Usage

powerpipe query kubernetes_insights.query.job_host_table

Steampipe Tables

SQL

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_job
order by
name;

Dashboards

The query is used in the dashboards: