turbot/azure_insights

Query: network_load_balancers_for_network_public_ip

Usage

powerpipe query azure_insights.query.network_load_balancers_for_network_public_ip

Steampipe Tables

SQL

select
lower(lb.id) as load_balancer_id
from
azure_lb as lb,
jsonb_array_elements(frontend_ip_configurations) as c
left join azure_public_ip as p on lower(p.id) = lower(c -> 'properties' -> 'publicIPAddress' ->> 'id')
where
lower(p.id) = $1;