Query: virtual_network_overview

select
  name as "Name",
  provisioning_state as "Provisioning State",
  cloud_environment as "Cloud Environment",
  region as "Region",
  resource_group as "Resource Group",
  subscription_id as "Subscription ID",
  id as "ID"
from
  azure_virtual_network
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);