I just had to write a script to find all storage accounts with blobs present in a specific subscription in a specific region.
This proved to be non-trivial as the storage account function doesn’t have a region filter, and you have to manually crawl the accounts to see if they’re using blobs.
Here is the fully-working script I came up with, I hope it helps you out!
rm -f accounts_with_blobs.csv tenant="your-tenant-id" subscription="your-subscription-name" region="your-region" az login --tenant "${tenant}" --subscription "${subscription}" # Get all subscription + region filtered storage account names. accounts=$(az storage account list --output table --subscription "${subscription}" | grep "${region}" | awk '{print $5}') # Filter out accounts with no blob containers. for account in $accounts do char_count=$(az storage container list --account-name $account | wc -c) if [[ $char_count -lt 4 ]]; then echo "$account has no blobs." else echo "$account has blobs." echo "$account" >> accounts_with_blobs.csv fi done