get azure subscriptions‘ all stroages，containers and blobs by PowerShell

导到excel里

# Add your Azure account to the local PowerShell environment.Add-AzureRmAccount -Environment AzureChinaCloud$x=1$excel = New-Object -ComObject Excel.Application $excel.Visible = $true$workbook = $excel.Workbooks.add()$sheet = $workbook.worksheets.Item(1)$SubscriptionNames = Get-AzureRMSubscriptionforeach ($sub in $SubscriptionNames){    $subname=$sub.name    $sheet.cells.item($x, 1) = "SubscriptionName"    $x++    $sheet.cells.item($x, 1) = $subname    $x++    Select-AzureRMSubscription -SubscriptionName $subname    $StorageAccountNames=Get-AzureRmStorageAccount    foreach($str in $StorageAccountNames)    {        $strname=$str.StorageAccountName        $strrg=$str.ResourceGroupName        $sheet.cells.item($x, 2) = "ResourceGroup"        $x++        $sheet.cells.item($x, 2) = $strrg        $x++        $sheet.cells.item($x, 3) = "storage account name"        $x++        $sheet.cells.item($x, 3) = $strname        $x++        $StorageAccountKey = Get-AzurermStorageaccountKey -ResourceGroupName $strrg -Name $strname        $Ctx = New-AzureStorageContext $strname -StorageAccountKey $StorageAccountKey.GetValue(0).value             $containers=Get-AzureStorageContainer -Context $Ctx    $sheet.cells.item($x, 4) = "container"        $x++       foreach($con in $containers)        {             $conname=$con.Name             $sheet.cells.item($x, 4) = $conname             $x++             $blobs=Get-AzureStorageBlob -Context $ctx               -Container $conname             $sheet.cells.item($x, 5) = "blob"             $x++             foreach($blob in $blobs)             {                 $blob2=$blob                 $sheet.cells.item($x, 5) = $blob2.Name                  $sheet.cells.item($x,2) = $blob2.BlobType                  $x++             }        }        }}