turbot/azure_insights

Query: network_public_ips_for_network_load_balancer

Usage

powerpipe query azure_insights.query.network_public_ips_for_network_load_balancer

Steampipe Tables

SQL

select
lower(ip.id) as public_ip_id
from
azure_lb as lb,
jsonb_array_elements(frontend_ip_configurations) as f
left join azure_public_ip as ip on lower(ip.id) = lower(f -> 'properties' -> 'publicIPAddress' ->> 'id')
where
(f -> 'properties' -> 'publicIPAddress' ->> 'id') is not null
and lower(lb.id) = $1