PowerShell выводит список виртуальных каталогов внутри учетной записи хранения Azure

Я заметил несколько учетных записей хранения с каталогами проектов внутри каталога «внутренний» и попытался перечислить их все в выходных данных.

В моей среде в моей учетной записи хранения Azure есть каталог с подкаталогами, например zoom/recording/BBS/2024-8-7.

Портал:

Вы можете использовать приведенный ниже скрипт, чтобы получить storage account details (filtered by tags), storage account size, container(filtered by specific container), Particular directory and their subdirectory из отфильтрованных контейнеров.

Скрипт:

Connect-AzAccount -Tenant 'xxxxx' -UseDeviceAuthentication

# Get all subscriptions
$subscriptions = Get-AzSubscription

# Define the tag key to filter by
$tagKey = "createdby"

# Initialize an array to store the results
$results = @()

foreach ($subscription in $subscriptions) {
    # Set the current subscription context
    Set-AzContext -SubscriptionId $subscription.Id

    # Get all storage accounts in the current subscription
    $storageAccounts = Get-AzStorageAccount | Where-Object { $_.Tags.ContainsKey($tagKey) }

    foreach ($storageAccount in $storageAccounts) {
        # Get the metrics for the storage account
        $resourceId = "/subscriptions/$($subscription.Id)/resourceGroups/$($storageAccount.ResourceGroupName)/providers/Microsoft.Storage/storageAccounts/$($storageAccount.StorageAccountName)"
        $uri = "https://management.azure.com$resourceId/providers/Microsoft.Insights/metrics?api-version=2023-10-01&metricnames=UsedCapacity&aggregation=Average"

        try {
            $response = Invoke-AzRestMethod -Method Get -Uri $uri
            $metrics = $response.Content | ConvertFrom-Json
            $usedCapacityMetric = $metrics.value | Where-Object { $_.name.value -eq "UsedCapacity" }

            if ($usedCapacityMetric) {
                $averageCapacity = $usedCapacityMetric.timeseries.data.average | Measure-Object -Sum | Select-Object -ExpandProperty Sum
            } else {
                $averageCapacity = 0
            }
        } catch {
            Write-Warning "Failed to retrieve metrics for storage account: $($storageAccount.StorageAccountName)"
            $averageCapacity = 0
        }

        $ctx = $storageAccount.Context
        $containers = Get-AzStorageContainer -Context $ctx | Where-Object { $_.Name -eq "test" }

       foreach ($container in $containers) {
          $blobs = Get-AzStorageBlob -Container $container.Name -Context $ctx | Where-Object { $_.Name -like "zoom/*" }

          # Extract unique directories within the "zoom" directory
          $directories = $blobs | ForEach-Object {
                $parts = $_.Name.Split('/')
                for ($i = 0; $i -lt $parts.Length - 1; $i++) {
                    $parts[0..$i] -join '/'
                }
            } | Sort-Object -Unique

          $results += [PSCustomObject]@{
            SubscriptionName     = $subscription.Name
            ResourceGroup        = $storageAccount.ResourceGroupName
            StorageAccount       = $storageAccount.StorageAccountName
            ContainerName        = $container.Name
            UsedCapacityInBytes  = $averageCapacity
            TagName              = $tagKey
            TagValue             = $storageAccount.Tags[$tagKey]
            Directories          = $directories -join ", "
            }
        }
    }
}

# Output the results
$results | Format-Table -AutoSize 

Выход:

SubscriptionName                      ResourceGroup StorageAccount ContainerName UsedCapacityInBytes TagName   TagValue Directories                                                          
----------------                      ------------- -------------- ------------- ------------------- -------   -------- -----------                                                          
xxxxxx xxxxxx xxxxxxxxxx Subscription venkatesan-rg venkat891      test                     45155865 createdby venkat   zoom, zoom/recording, zoom/recording/BBS, zoom/recording/BBS/2024-8-7