Query: compute_virtual_machine_overview

select
  name as "Name",
  vm_id as "Virtual Machine ID",
  type as "Type",
  provisioning_state as "Provisioning State",
  size as "Size",
  os_type as "OS Type",
  identity ->> 'type' as "Identity",
  region as "Region",
  resource_group as "Resource Group",
  subscription_id as "Subscription ID",
  id as "ID"
from
  azure_compute_virtual_machine
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);