Print out all of the resources in a subscription (starting with SQL databases)

List-AzureResources.ps1

Login-AzureRmAccount

$OutFilePath = "D:\sql-databases.csv"

ForEach ($resourceGroup in Get-AzureRmResourceGroup)
{
    ForEach ($sqlServer in Get-AzureRMSqlServer -ResourceGroupName $resourceGroup.ResourceGroupName)  
    { 
        ForEach($sqlDatabase in Get-AzureRMSqlDatabase -ServerName $sqlServer.ServerName -ResourceGroupName $resourceGroup.ResourceGroupName) 
        { 
            If($sqlDatabase.Name -ine "master") 
            { 
                $sqlServer.ServerName + "," + $sqlDatabase.DatabaseName + "," + $sqlDatabase.Edition + "," + $sqlDatabase.Location + "," + $sqlDatabase.CurrentServiceObjectiveName | out-file $OutFilePath -encoding ascii -append 
            } 
        } 
    }     
}