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

Question

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

Answer 1

Hi Monalisa,

Sorry to say but Azure Resource Graph does not support retrieving historical data. Azure Resource Graph is designed to provide instant access to resource configuration data for your entire environment, but it does not track or provide historical data.

For tracking storage account usage over time, you might want to consider using Azure Monitor, which can collect and analyze log data, create visualizations, and set up alerts based on your data. Specifically, Azure Monitor's Metrics feature can track the used capacity of your storage account over time.

Please note that you would need to set up Azure Monitor to start collecting this data, as it does not provide historical data from before the setup.

To start collecting data for tracking storage account usage over time using Azure Monitor, you can enable logging and metrics for your storage accounts. Here's how you can do it:

Azure Storage Analytics allows you to collect performance data for Azure Storage services like Blob Storage, Table Storage, and Queue Storage. You can specify whether you want the storage service to collect and aggregate metrics every hour or every minute.

Once you have enabled metrics, you can view them in the Azure portal and configure rules that notify administrators by email whenever a metric exceeds a particular threshold.

You can also use Azure Monitor Logs to collect, analyze, and visualize log data from your applications and systems. By aggregating logs, you can cross-query events and gain insights into the performance of your application.

For more information, you can refer to the following Azure documentation:

• Recommendations for collecting performance data - Azure facilitation
• Monitor, diagnose, and troubleshoot Microsoft Azure Storage (classic) - Monitoring your storage service
• Monitoring your storage service with Azure Monitor Storage insights - View from a storage account

Kindly accept answer if it helps,

Thanks

Deepanshu

Answer 2

Hi @Deepanshu katara

Once I have set Azure monitor for the same, can you please help me how I can query the below columns with the historical data of storage accounts.

Thanks

Monalisa