turbot/kubernetes_insights

Query: nodes_for_cronjob

Usage

powerpipe query kubernetes_insights.query.nodes_for_cronjob

SQL

select
n.uid as uid
from
kubernetes_job as j,
jsonb_array_elements(j.owner_references) as j_owner,
kubernetes_pod as pod,
jsonb_array_elements(pod.owner_references) as pod_owner,
kubernetes_node as n
where
n.name = pod.node_name
and pod_owner ->> 'uid' = j.uid
and j.context_name = pod.context_name
and j_owner ->> 'uid' = $1;