Query: compute_virtual_machine_scale_set_vm_input

select
  vm.title as label,
  lower(vm.id) as value,
  json_build_object(
    'subscription',
    s.display_name,
    'resource_group',
    vm.resource_group,
    'region',
    vm.region
  ) as tags
from
  azure_compute_virtual_machine_scale_set_vm as vm,
  azure_subscription as s
where
  vm.subscription_id = s.subscription_id
order by
  vm.title;