Enumerates through all storage accounts in an Azure Resource Manage subscription and returns the total number of Storage Accounts, Containers and Blobs as well as the total time to execute.

Get-AllStorageAccountTotals.ps1

$subsciptionId = "<Azure Subscription ID>"

Select-AzureRmSubscription -SubscriptionId $subsciptionId

$startTime = Get-Date
$storageAccounts = Get-AzureRmStorageAccount

$totalStorageAccounts = $($storageAccounts.Count)
$totalContainers = $null
$totalBlobs = $null

foreach($storageAccount in $storageAccounts) {
    Write-Output "Storage Account Name: $($storageAccount.StorageAccountName)"
    $storageAccountKey = $null; $storageAccountContext = $null
    $storageAccountKey = ((Get-AzureRmStorageAccountKey -ResourceGroupName $storageAccount.ResourceGroupName -Name $storageAccount.StorageAccountName) | Where-Object KeyName -eq "key1").Value
    $storageAccountContext = New-AzureStorageContext –StorageAccountName $storageAccount.StorageAccountName -StorageAccountKey $storageAccountKey
    $storageAccountContainers = Get-AzureStorageContainer -Context $storageAccountContext
    $totalContainers += $storageAccountContainers.Count
   
    if($storageAccountContainers.Count -gt 0) {
        Write-Output "`tContainer count: $($storageAccountContainers.Count)"
        foreach($storageAccountContainer in $storageAccountContainers) {
            $blobs = Get-AzureStorageBlob -Context $storageAccountContext -Container $storageAccountContainer.Name
            Write-Output "`t$($storageAccountContainer.Name) - Number of blobs: $($blobs.Count)"
            $totalBlobs += $blobs.Count
        }
        Write-Output ""
    }
    else {
        Write-Output "`tContainer count: 0`n`r"
    }
}

$endTime = Get-Date
Write-Output "Total Storage Accounts: $totalStorageAccounts"
Write-Output "Total Containers: $totalContainers"
Write-Output "Total Blobs: $totalBlobs"
Write-Output "Start Time: $($startTime)"
Write-Output "End Time: $(Get-Date)"
Write-Output "Total runtime(minutes): $((New-TimeSpan -Start $startTime -End $endTime).TotalMinutes)"