Query: compute_virtual_machine_scale_set_network_interface

select
  nic ->> 'name' as "Name",
  -- (nic -> 'properties' ->> 'enableAcceleratedNetworking')::boolean as "Enable Accelerated Networking",
  (nic -> 'properties' ->> 'enableIPForwarding') :: boolean as "Enable IP Forwarding",
  (nic -> 'properties' ->> 'primary') :: boolean as "Primary",
  -- nic -> 'properties' -> 'networkSecurityGroup' ->> 'id' as "Network Security Group ID",
  ip ->> 'name' as "IP Config Name",
  -- ip -> 'properties' -> 'loadBalancerBackendAddressPools' as "Load Balancer Backend Address Pools",
  -- ip -> 'properties' -> 'loadBalancerInboundNatPools' as "Load Balancer Inbound Nat Pools",
  (ip -> 'properties' ->> 'primary') :: boolean as "IP Primary",
  ip -> 'properties' ->> 'privateIPAddressVersion' as "Private IP Address Version" -- ip -> 'properties' -> 'subnet' ->> 'id' as "IP Subnet ID"
from
  azure_compute_virtual_machine_scale_set,
  jsonb_array_elements(
    virtual_machine_network_profile -> 'networkInterfaceConfigurations'
  ) nic,
  jsonb_array_elements(nic -> 'properties' -> 'ipConfigurations') ip
where
  lower(id) = $1;