Query: compute_virtual_machine_scale_sets_for_network_load_balancer

select
  lower(vm_scale_set.id) as compute_virtual_machine_scale_set_id
from
  azure_compute_virtual_machine_scale_set as vm_scale_set,
  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
where
  lower(split_part(b ->> 'id', '/backendAddressPools', 1)) = $1