Need to get a list of all Storage accounts along with Blob containers where "Last modified Date" is older than 90 days

Girish Binani 0 Reputation points

I am looking to find a way to get an excel list of all storage accounts across the tenant with the containers that have not been modified for last 90 days i.e. storage accounts that have been inactive for more than 90 days and didn't have any Read/Write operations. This will help in cleaning up the storages that are not needed and also for changing the access tier to "Cool" and "Archive" for the ones that are accessed infrequently.

PS: We are trying not to use the Storage Lifecycle management as that will incur additional costs which we would like to avoid.

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,109 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
1,937 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Thomas Meads 571 Reputation points


    If you go to the Azure portal and go to Monitor. On the left you will see Storage Accounts. This will present you with a workbook where you can select the Storage Accounts and the time range. Once selected you will see all the metrics for those accounts in the last x days along with the transactions they have received. Additionally this data can be exported to Excel via this view.

    If you have set rules on these storage accounts for moving to cool and archived tiers then I'd recommend looking at This would allow you to setup these rules so that they automatically happen. It might be possible to use something like Azure Policy to apply these rules automatically but that is out of the range of knowledge I have.

    Hope this helps.