turbot/azure_insights

Query: network_load_balancer_backend_address_pools_for_network_load_balancer

Usage

powerpipe query azure_insights.query.network_load_balancer_backend_address_pools_for_network_load_balancer

SQL

select
lower(p.id) as pool_id
from
azure_lb as lb,
jsonb_array_elements(backend_address_pools) as b
left join azure_lb_backend_address_pool as p on lower(p.id) = lower(b ->> 'id')
where
lower(lb.id) = $1;