how to find out which of the resources are linked to a storage account?

Question

I need a way of finding out which one of the Azure resources are linked to a storage account and which one of the storage accounts is it. There are A LOT of resources, about 2000.

I really don't know how to go about this. Can't use PowerShell or Cloud Shell because of user restrictions.

Answer 1

If you don't want to implement it PowerShell or CLI, you can use Azure storage explorer or Azure resource graph queries.

Check below:

1. Azure storage explorer:

Download it into your local environment with the help of the given link and then sign into your Azure account. Now you will be able to view all the storage account information specifically as shown.

2. Azure resource graph:

Use below query in resource graph explorer to view the required data.

resources
| where type == "Microsoft.Storage/storageAccounts"
| project StorageAccountName = name, ResourceId = id
| join kind=inner (ResourceContainers | project ResourceId, ResourceName, ResourceType) 
on $left.ResourceId == $right.ResourceId
| project StorageAccountName, ResourceGroup

3. You can also check service endpoints under settings of each storage account to know the linked specific blob/file/queue services as shown.