azure Cli - Making multiple subscription as default

2
votes

I am working to find the list of all the storage account in our Azure subscription. Unfortunately, we have around 40 subscriptions, is there a way to get all the storage account. Currently I can only see the list in one subscription & need to change the subscription to another for finding the storage account.

The following command gives me the storage account for default subscription:
az storage account list --output table

1
azure
did you have chance to check my answer? – Farrukh Normuradov

1 Answers

0
votes

Please install the graph extension:
az extension add --name resource-graph

And then try out the following:

az graph query -q                                         \
"Resources                                                \
| join kind=leftouter                                     \
    (                                                     \
        ResourceContainers                                \
        | where type=='microsoft.resources/subscriptions' \
        | project SubName=name, subscriptionId            \
    ) on subscriptionId                                   \
| where type == 'microsoft.storage/storageaccounts'       \
| project type, name, SubName"

Here I found the resources types.
I changed the casing to make it work.
This documentation gave me the hints to make the query work.