how to get storage accounts capacity usage for 1400 storage accounts

Question

how to get storage accounts capacity usage for 1400 storage accounts

Answer 1

You can use scripting:

# Define your subscription ID
$subscriptionId = "YourSubscriptionId"
# Get all storage accounts in the subscription
$storageAccounts = Get-AzStorageAccount -SubscriptionId $subscriptionId
# Loop through each storage account
foreach ($storageAccount in $storageAccounts) {
    # Get storage account name
    $storageAccountName = $storageAccount.StorageAccountName
    # Get storage account key (assuming you have the necessary permissions)
    $storageAccountKey = (Get-AzStorageAccountKey -ResourceGroupName $storageAccount.ResourceGroupName -Name $storageAccountName).Value[0]
    # Create a storage context
    $context = New-AzStorageContext -StorageAccountName $storageAccountName -StorageAccountKey $storageAccountKey
    # Get storage account properties
    $properties = Get-AzStorageAccount -ResourceGroupName $storageAccount.ResourceGroupName -Name $storageAccountName
    # Extract relevant information (adjust as needed)
    $capacity = $properties.PrimaryEndpoints.Blob + "?comp=properties"
    $capacityInfo = Invoke-RestMethod -Uri $capacity -Method GET -Headers @{"x-ms-version"="2020-08-04"} -UseBasicParsing
    # Output storage account and capacity information
    Write-Host "Storage Account: $($storageAccount.StorageAccountName)"
    Write-Host "Capacity Usage: $($capacityInfo.totalCapacity)"
    Write-Host "---------------------------"
}

---

hth Marcin