turbot/kubernetes_insights

Query: service_ip_details

Usage

powerpipe query kubernetes_insights.query.service_ip_details

Steampipe Tables

SQL

select
cluster_ip as "Cluster IP",
l ->> 'ip' as "Load Balancer IP",
external_ips as "External IPs"
from
kubernetes_service,
jsonb_array_elements(load_balancer_ingress) as l
where
uid = $1
union
select
cluster_ip as "Cluster IP",
load_balancer_ingress::text as "Load Balancer IP",
external_ips as "External IPs"
from
kubernetes_service
where
uid = $1 and load_balancer_ingress is null;

Params

ArgsNameDefaultDescriptionVariable
$1uid

    Dashboards

    The query is used in the dashboards: