turbot/kubernetes_insights

Query: pod_container_basic_detail

Usage

powerpipe query kubernetes_insights.query.pod_container_basic_detail

Steampipe Tables

SQL

select
c ->> 'name' as "Name",
c ->> 'image' as "Image",
c -> 'securityContext' -> 'seccompProfile' ->> 'type' as "Seccomp Profile Type",
concat(c ->> 'name',name) as "Container Value"
from
kubernetes_pod,
jsonb_array_elements(containers) as c
where
uid = $1
order by
c ->> 'name';

Params

ArgsNameDefaultDescriptionVariable
$1uid

    Dashboards

    The query is used in the dashboards: