Query: virtual_network_address_prefixes

select
  (trim('"' FROM p::text))::cidr as "Address Prefix",
  power(2, 32 - masklen( (trim('"' FROM p::text) ):: cidr)) as "Total IPs"
from
  azure_virtual_network,
  jsonb_array_elements(address_prefixes) as p
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);