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
  and subscription_id = split_part($1, '/', 3);