turbot/kubernetes_insights

Query: cronjob_host_table

Usage

powerpipe query kubernetes_insights.query.cronjob_host_table

Steampipe Tables

SQL

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;

Dashboards

The query is used in the dashboards: