Query: network_interface_ip_configurations_details

select
  c ->> 'name' as "Name",
  c -> 'properties' ->> 'primary' as "Primary",
  c -> 'properties' ->> 'privateIPAddress' as "Private IP Address",
  c -> 'properties' ->> 'privateIPAddressVersion' as "Private IP Address Version",
  c -> 'properties' ->> 'privateIPAllocationMethod' as "Private IP Allocation Method",
  c -> 'properties' -> 'subnet' ->> 'id' as "Subnet",
  c ->> 'id' as "ID"
from
  azure_network_interface,
  jsonb_array_elements(ip_configurations) as c
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3)
order by
  c ->> 'name';