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

Question

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.

Answer 1

Hi,

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 https://learn.microsoft.com/en-us/azure/storage/blobs/lifecycle-management-overview. 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.