turbot/kubernetes_insights

Query: container_ports

Usage

powerpipe query kubernetes_insights.query.container_ports

Steampipe Tables

SQL

select
p ->> 'name' as "Name",
p ->> 'protocol' as "Protocol",
p ->> 'containerPort' as "Container Port"
from
kubernetes_pod,
jsonb_array_elements(containers) as c,
jsonb_array_elements(c -> 'ports') as p
where
concat(c ->> 'name',name) = $1
order by
p ->> 'name';

Params

ArgsNameDefaultDescriptionVariable
$1name

    Dashboards

    The query is used in the dashboards: