How to access storage accounts file share list in automation runbook using PowerShell without endpoint

Question

I'm having task to get all the storage accounts in the multiple azure subscription to enable backup on file share.Is it possible when public network access disabled on the storage account. I don't want to go with private endpoint solution as I have lot of storage account to backup. Any other ways to get list of storage accounts and their file share without private endpoint and public network access disabled.Appreciate help here

Answer 1

Hello there,

To get a list of all storage accounts created in Microsoft Azure, run below PowerShell command from a computer where Azure PowerShell cmdlets version 1.0 is installed:

Get-AzureRmStorageAccount | export-CSV AzureStorageAccounts.CSV

You could use Microsoft.Azure.Management.Fluent to list all the storage account in your subscription.

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer--

Answer 2

@Shekar Yenagandula I did some testing and see that the below Powershell script is giving output of fileshares for multiple subscriptions.

Please try the below script and let me know if this helps. This script will work for storage accounts with public network access enabled or disabled. However, if public network access is disabled, you will need to use a service principal or managed identity to authenticate the PowerShell session. You can use the Azure AD PowerShell cmdlets to create a service principal and grant it access to the storage accounts you want to backup. Then, you can use the service principal credentials to sign in to Azure and run the script.

foreach ($subscription in $subscriptions)                                              
 {Get-AzSubscription -SubscriptionName $subscription.Name | Set-AzContext
 # Get the list of storage accounts
    $storageAccounts = Get-AzStorageAccount
 # Loop through each storage account
     foreach ($storageAccount in $storageAccounts)
     {
# Get the list of file shares in the storage account
    $fileShares = Get-AzStorageShare -Context $storageAccount.Context
 # Print the storage account name and file share names
   Write-Output "Storage account: $($storageAccount.StorageAccountName)"
    Write-Output "File shares: $($fileShares.Name -join ", ")"
} 
}