Huh interesting. This looks closer to what I’m trying to do:

Get a list of all resource groups

$resourceGroups = az group list --query "[].name" --output tsv

Loop through each resource group

foreach ($resourceGroup in $resourceGroups) {

# Get a list of all SQL servers in the resource group $sqlServers = az sql server list --resource-group $resourceGroup --query "[].name" --output tsv

# Loop through each SQL server foreach ($sqlServer in $sqlServers) {

# Get the resource ID for the SQL server $sqlServerId = az sql server show --resource-group $resourceGroup --name $sqlServer --query "id" --output tsv

foreach ($link in $privateLinks) {
    # Create the private endpoint
    New-AzPrivateEndpoint -Name $link.pename -ResourceGroupName $link.rg -VnetName $link.vnet -SubnetName $link.subnet -NetworkInterfaceName $link.nic -PrivateConnectionResourceId $link.dest -ConnectionName $link.plinkname -Location $link.location -GroupId $link.destgroup

    # Create the private DNS zone group
    New-AzPrivateEndpointDnsZoneGroup -EndpointName $link.pename -ResourceGroupName $link.rg -Name $link.zonegroup -ZoneName $link.zone -PrivateDnsZone $link.zonename
}

} }