Query: network_load_balancer_backend_address_pools_for_compute_virtual_machine_scale_set

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;