turbot/kubernetes_insights

Query: job_conditions

Usage

powerpipe query kubernetes_insights.query.job_conditions

Steampipe Tables

SQL

select
c ->> 'lastTransitionTime' as "Last Transition Time",
c ->> 'lastUpdateTime' as "Last Update Time",
c ->> 'message' as "Message",
c ->> 'reason' as "Reason",
c ->> 'status' as "Status",
c ->> 'type' as "Type"
from
kubernetes_job,
jsonb_array_elements(conditions) as c
where
uid = $1
order by
c ->> 'lastTransitionTime' desc;

Params

ArgsNameDefaultDescriptionVariable
$1uid

    Dashboards

    The query is used in the dashboards: