Query: compute_virtual_machine_scale_set_overview

select
  name as "Name",
  unique_id as "Scale Set ID",
  type as "Type",
  provisioning_state as "Provisioning State",
  identity ->> 'type' as "Identity",
  upgrade_policy ->> 'mode' as "Upgrade Policy Mode",
  region as "Region",
  resource_group as "Resource Group",
  id as "ID"
from
  azure_compute_virtual_machine_scale_set
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);