Get All SQL Servers (or any resource type) #PowerShell #Azure

GetSQLServers.ps1

#az login
$subs = az account list | ConvertFrom-Json
$allServers = @()
foreach($sub in $subs){
    Write-Output $sub.Name
    az account set -s $sub.Id
    $subServers = az resource list --resource-type 'Microsoft.Sql/servers' | ConvertFrom-Json
    foreach($server in $subServers){
        $allServers += $server
    }
}

$allServers | Format-Table -Property name, kind, id