Groups VMs based on VM name using the beginning letters to the first digit to determine if vmGroup is spread across two or more availability zones. For output, it includes the tag, Application Name.

magic_zonal_redundancy_query.kql

resources 
| where type =~ 'microsoft.compute/virtualmachines'
| project vmId = id, vmName = name, vmZone = tostring(zones[0]), vmGroup = trim_end('\\d+$', name), appName = tags['Application Name'], location
| summarize vmCount = count(), zoneCount = dcountif(vmZone, isnotempty(vmZone)) by vmGroup
| where zoneCount < min_of(vmCount, 2)
| join kind=inner(
    resources
    | where type=~ 'microsoft.compute/virtualmachines'
    | project vmId = id, vmName = name, vmZone = tostring(zones[0]), vmGroup = trim_end('\\d+$', name), appName = tags['Application Name'], location) on vmGroup
| project vmGroup, vmName, location, vmZone, vmId, appName