turbot/kubernetes_insights

Query: deployments_for_pod

Usage

powerpipe query kubernetes_insights.query.deployments_for_pod

SQL

select
rs_owner ->> 'uid' as uid
from
kubernetes_replicaset as rs,
jsonb_array_elements(rs.owner_references) as rs_owner,
kubernetes_pod as pod,
jsonb_array_elements(pod.owner_references) as pod_owner
where
pod.uid = $1
and rs.context_name = pod.context_name
and pod_owner ->> 'uid' = rs.uid;