Query: compute_virtual_machine_scale_set_vm_overview

select
  name as "Name",
  instance_id as "Instance ID",
  type as "Type",
  provisioning_state as "Provisioning State",
  model_definition_applied as "Model Definition Applied",
  vm_id as "VM ID",
  region as "Region",
  resource_group as "Resource Group",
  id as "ID"
from
  azure_compute_virtual_machine_scale_set_vm
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);