Login-AzureRmAccount 
Save-AzureRmProfile -Path “C:\Work\PS\azureaccount.json”

GetAzureResourceList -RmProfilePath $RmProfilePath -PublishSettingsFilePath $PublishSettingsFilePath

function GetAzureResourceList() 
{ 
    param 
    ( 
        [string] 
        $RmProfilePath =$(throw "Parameter missing: -RmProfilePath RmProfilePath"),  
        [string] 
        $PublishSettingsFilePath = $(throw "Parameter missing: -PublishSettingsFilePath PublishSettingsFilePath"), 
        [string] 
        $OutFilePath = "c:\AzureResourceList.csv" 
    ) 
      
    Try 
    { 
        #Loads Azure authentication information from a file using Resource Manager.https://portal.azure.com 
        Select-AzureRmProfile –Path $RmProfilePath -ErrorAction Stop 
 
        #Imports a publish-settings file with a certificate to connect to your Windows Azure account using Server Manager.https://manage.windowsazure.com/publishsettings/ 
        Import-AzurePublishSettingsFile -PublishSettingsFile $PublishSettingsFilePath -ErrorAction Stop 
 
        "Resource Type,Resource Name,Resource Status" | out-file $OutFilePath -encoding ascii -append 
        #Get classic VM list 
        ForEach ($classicVM in Get-AzureVM)  
        { 
            "Virtual machines(classic)," + $classicVM.Name + "," + $classicVM.Status | out-file $OutFilePath -encoding ascii -append 
        } 
        #Get resource manager VM  
        ForEach ($rmVM in Get-AzureRmVM)  
        { 
            $statuses = (Get-AzureRmVM -ResourceGroupName $rmVM.ResourceGroupName -Name $rmVM.Name -Status).Statuses  
            "Virtual machines," + $rmVM.Name + "," + $statuses.DisplayStatus | out-file $OutFilePath -encoding ascii -append 
        } 
 
        #Get classic storage accounts list 
        ForEach ($storageAccount in Get-AzureStorageAccount)  
        { 
            "Storage Account(classic)," + $storageAccount.StorageAccountName + ",Available" | out-file $OutFilePath -encoding ascii -append 
        } 
        #Get resource manager storage accounts list 
        ForEach ($rmStorageAccount in Get-AzureRmStorageAccount)  
        { 
            "Storage Account," + $rmStorageAccount.StorageAccountName + "," +  $rmStorageAccount.StatusOfPrimary | out-file $OutFilePath -encoding ascii -append 
        } 
        #Get SQL databases 
        ForEach ($sqlServer in Get-AzureSqlDatabaseServer)  
        { 
            ForEach($sqlDatabase in Get-AzureSqlDatabase -ServerName $sqlServer.ServerName) 
            { 
                If($sqlDatabase.Name -ine "master") 
                { 
                    "SQL databases," + $sqlDatabase.Name + ",Online"  | out-file $OutFilePath -encoding ascii -append 
                } 
            } 
        }     
        #Get-AzureRmResource cmdlet can get all azure resources 
        #Get App Services 
        ForEach ($resource in Get-AzureRmResource)  
        { 
            If($resource.ResourceType -ieq "Microsoft.Web/sites") 
            { 
                $webApp = Get-AzureRmWebApp -Name $resource.ResourceName 
                "App Services," + $resource.ResourceName + "," +  $webApp.State | out-file $OutFilePath -encoding ascii -append 
            } 
        }         
    } 
    Catch 
    {         
          Write-Host -ForegroundColor Red $_.Exception.Message 
    } 
} 
 
GetAzureResourceList -RmProfilePath "C:\Work\PS\azureaccount.json" -PublishSettingsFilePath "C:\Work\AzureCredentials\Visual Studio Ultimate with MSDN-8-2-2016-credentials.publishsettings" 
Write-Host "Done"