Below script works form me.
az monitor scheduled-query list --query "[?tags.regionspecific=='yes'].{name:name, resourceGroup:resourceGroup}" -o tsv |
while IFS=$'\t' read -r alert_name resource_group; do
echo "Disabled log query alert rule: $alert_name in resource group: $resource_group"
done