List Containers April 7, 2025 by admin

This PowerShell script is written to connect to Azure, loop through all subscriptions under a specific tenant, and for each storage account in each subscription, list each unique container.

Connect-AzAccount
$allContext = Get-AzSubscription | Where-Object { $_.TenantId -eq "xxxxxxx" }
foreach ( $context in $allContext ) {
 Select-AzSubscription -SubscriptionId  $context.id

# Get the storage account context
$storageAccount = ""
$a= ""
$storageAccount = Get-AzStorageAccount 
foreach ($storage in $storageAccount)
{
$ctx=(Get-AzStorageAccount -ResourceGroupName $storage.ResourceGroupName -Name $storage.StorageAccountName).Context
$containers = Get-AzStorageContainer -Context $ctx | Sort-Object Name,SnapshotTime -Descending
              $containers =  $containers | Group-Object Name | ForEach-Object { $_.Group | Select-Object -First 1 } 
       Foreach ( $containers in $containers ) {"Container;"+$context.Name+";"+$storage.ResourceGroupName+";"+$storage.StorageAccountName+";"+$containers.Name }


}
}