Hi Everyone,

I am working on obtaining the total amount of storage space as you can see below, I can get that inside the Monitor>Insights>Storage Accounts, but I want to find a way to obtain that same value using a script either PowerShell or Bash, been working on some CLI commands but none of them are working, has somebody done this or can you point me in the right direction please.

Thank You for your time

Best Regards.

Advay Thombare

Hi Keshavulu Dasari,
i will definitely try to replicate this on my end and will get back here if it worked.

Thanks for your comment.

Hi Advay Thombare,

If you have any other questions or are still running into more issues, let me know in the "comments" and I would be glad to assist you. Good luck with your implementation.

Hi Advay Thombare,

If you have any other questions or are still running into more issues, let me know in the "comments" and I would be glad to assist you.

Thank you @Keshavulu Dasari , the final script worked. Used a few modifications.

#!/bin/bash

Print header

echo "UsedCapacity(Bytes),SubscriptionName,SubscriptionID,StorageAccountName,ResourceGroup,Location" az account list --query "[].{name:name, id:id}" -o tsv | dos2unix | while IFS=$'\t' read -r sub_name sub_id; do if az account set --subscription "$sub_id" 2>/dev/null; then az storage account list --query "[].{name:name, resourceGroup:resourceGroup, location:primaryLocation}" -o tsv | while IFS=$'\t' read -r storage_name resource_group location; do url="https://management.azure.com/subscriptions/$sub_id/resourceGroups/$resource_group/providers/Microsoft.Storage/storageAccounts/$storage_name/providers/microsoft.insights/metrics?api-version=2018-01-01&metricnames=UsedCapacity" read -r used_capacity timestamp <<< "$(az rest --method get --url "$url" --query "value[0].timeseries[0].data[-1]" -o tsv 2>/dev/null)"; echo ""${used_capacity}","${sub_name}","${sub_id}","${storage_name}","${resource_group}","${location}""; done; else echo "Failed to set subscription: $sub_name ($sub_id)" >&2; fi; done

Hi @Advay Thombare

How to obtain total storage used by all subscriptions and subsequent storage accounts in GB or TB with a script?

You can use the below PowerShell script to get the used capacity of all Azure Storage accounts in GB.

Script:

Connect-AzAccount -Tenant 'xxxx-xxxx-xxxx-xxxx'

$subs = Get-AzSubscription

$subs | ForEach-Object {
    Set-AzContext -SubscriptionId $_.Id
    Write-Host "`nProcessing Subscription: $($_.Name)" -ForegroundColor Cyan

    $resourceGroups = Get-AzResourceGroup
    $results = @()

    foreach ($rg in $resourceGroups) {
        $rgName = $rg.ResourceGroupName
        Write-Host "`nChecking resource group: $rgName" -ForegroundColor Yellow

        $storageAccounts = Get-AzStorageAccount -ResourceGroupName $rgName

        foreach ($sa in $storageAccounts) {
            $storageName = $sa.StorageAccountName
            $saId = $sa.Id

            $metric = Get-AzMetric -ResourceId $saId -MetricName "UsedCapacity" -WarningAction SilentlyContinue

            if ($metric -and $metric.Data.Count -gt 0) {
                $averageBytes = ($metric.Data | Where-Object { $_.Average -ne $null } | Select-Object -Last 1).Average
                $capacityInGB = [math]::Round($averageBytes / 1GB, 2)
            } else {
                $capacityInGB = 0
            }

            $results += [PSCustomObject]@{
                SubscriptionName    = $_.Name
                SubscriptionId      = $_.Id
                ResourceGroupName   = $rgName
                StorageAccountName  = $storageName
                UsedCapacityInGB    = $capacityInGB
            }
        }
    }

    # Display results
    $results | Format-Table SubscriptionName, SubscriptionId, ResourceGroupName, StorageAccountName, UsedCapacityInGB -AutoSize
}

Output:
Hope this answer helps! please let us know if you have any further queries. I’m happy to assist you further.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Advay Thombare
Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Advay Thombare

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Hi Venkatesan, the script worked. Thank you.

Hi Advay Thombare,

You can use either PowerShell or Bash to obtain the total storage used by all subscriptions and storage accounts. examples for both:

PowerShell Script

You can use the Get-AzMetric and Get-AzStorageAccountUsage cmdlets to retrieve the storage metrics:

# Login to your Azure account
Connect-AzAccount

# Set the context to the subscription that contains your storage account
Set-AzContext -SubscriptionId <SubscriptionId>

# Retrieve the total allocated size of the storage account
$storageAccountName = "<StorageAccountName>"
$resourceId = "/subscriptions/<SubscriptionId>/resourceGroups/<ResourceGroupName>/providers/Microsoft.Storage/storageAccounts/$storageAccountName"
$metric = Get-AzMetric -ResourceId $resourceId -TimeGrain PT1H -MetricName BlobCapacity -AggregationType Total -StartDate (Get-Date).AddDays(-1) -EndTime (Get-Date)
$totalSize = $metric.Data | Select-Object -ExpandProperty Total | Select-Object -First 1

# Retrieve the consumed size for each storage type
$usage = Get-AzStorageAccountUsage -ResourceGroupName <ResourceGroupName> -Name $storageAccountName
$blobSize = $usage | Where-Object {$_.Name.Value -eq "BlobCapacity"} | Select-Object -ExpandProperty CurrentValue
$tableSize = $usage | Where-Object {$_.Name.Value -eq "TableCapacity"} | Select-Object -ExpandProperty CurrentValue
$queueSize = $usage | Where-Object {$_.Name.Value -eq "QueueCapacity"} | Select-Object -ExpandProperty CurrentValue
$fileSize = $usage | Where-Object {$_.Name.Value -eq "FileCapacity"} | Select-Object -ExpandProperty CurrentValue

# Print the results
Write-Host "Total allocated size: $totalSize bytes"
Write-Host "Blob consumed size: $blobSize bytes"
Write-Host "Table consumed size: $tableSize bytes"
Write-Host "Queue consumed size: $queueSize bytes"
Write-Host "File consumed size: $fileSize bytes"

Bash Script

You can use the az rest command to invoke the Metrics API and parse the response:

# Set variables
subscriptionId="<SubscriptionId>"
resourceGroupName="<ResourceGroupName>"
storageAccountName="<StorageAccountName>"

# Get the metrics
response=$(az rest --uri "https://management.azure.com/subscriptions/$subscriptionId/resourceGroups/$resourceGroupName/providers/Microsoft.Storage/storageAccounts/$storageAccountName/providers/Microsoft.Insights/metrics?api-version=2018-01-01&metricnames=UsedCapacity&aggregation=Average")

# Parse the response to get the used capacity
usedCapacity=$(echo $response | jq '.value[0].timeseries[0].data[0].average')

# Print the result
echo "Used capacity: $usedCapacity bytes"

For more information:

https://techcommunity.microsoft.com/blog/azurepaasblog/calculate-the-sizecapacity-of-storage-account-and-it-services-blobtable/1064046

https://stackoverflow.com/questions/69732270/how-to-get-the-size-of-an-azure-storage-account-in-azure-cli-or-bash-script

If you have any other questions or are still running into more issues, let me know in the "comments" and I would be glad to assist you.