turbot/steampipe-mod-azure-insights

Query: network_load_balancer_backend_address_pools_for_compute_virtual_machine_scale_set

Usage

powerpipe query azure_insights.query.network_load_balancer_backend_address_pools_for_compute_virtual_machine_scale_set

SQL

select
lower(pool.id) as pool_id
from
azure_compute_virtual_machine_scale_set as s,
jsonb_array_elements(virtual_machine_network_profile -> 'networkInterfaceConfigurations' ) as p,
jsonb_array_elements(p -> 'properties' -> 'ipConfigurations' ) as c,
jsonb_array_elements(c -> 'properties' -> 'loadBalancerBackendAddressPools' ) as b
left join azure_lb_backend_address_pool as pool on lower(pool.id) = lower(b ->> 'id')
where
pool.id is not null
and lower(s.id) = $1
and s.subscription_id = split_part($1, '/', 3);