turbot/kubernetes_insights

Query: service_ports

Usage

powerpipe query kubernetes_insights.query.service_ports

Steampipe Tables

SQL

select
p ->> 'name' as "Name",
p ->> 'port' as "Port",
p ->> 'nodePort' as "Node Port",
p ->> 'protocol' as "Protocol",
p ->> 'targetPort' as "Target Port"
from
kubernetes_service,
jsonb_array_elements(ports) as p
where
uid = $1
order by
p ->> 'name';

Params

ArgsNameDefaultDescriptionVariable
$1uid

    Dashboards

    The query is used in the dashboards: