Kusto query to get Azure Storage account details with historical data (every week how much capacity consumed))

Hi Monalisa - Thanks for reaching out.

While you can pull the basic detail w.r.t. name, subscription details, RG etc, you won't be able to get a week wise capacity breakup directly. This is because there is no weekly based metric.

If you have configured to store transaction metrics, then you can query them to get an aggregated value or if you any kind of weekly inventory report, that might also help you calculating the weekly capacity of the account.

Please let us know if you have any further queries. I’m happy to assist you further.    

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Hi @Amrinder singh

Our requirement to get weekly capacity report of storage account and store them in storage account and club them and send to the recipients using automation powershell

can you please help on the same.

We are using below query to get capacity details

AzureMetrics | where ResourceProvider == "MICROSOFT.STORAGE"

Hi

can you please help on this