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

Monalisa 60 Reputation points
2024-06-19T16:07:56.2566667+00:00

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

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,906 questions
{count} votes

Accepted answer
  1. Deepanshukatara-6769 7,830 Reputation points
    2024-06-20T08:21:12.7433333+00:00

    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:

    Kindly accept answer if it helps,

    Thanks

    Deepanshu

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Monalisa 60 Reputation points
    2024-06-20T11:43:55.1833333+00:00

    Hi @Deepanshukatara-6769

    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.

    User's image

    Thanks

    Monalisa


  2. Monalisa 60 Reputation points
    2024-06-24T07:21:26.0033333+00:00

    sure @Deepanshukatara-6769

    Thanks for the update.

    I will execute as per above instructions and update the same.

    Regards

    Monalisa

    0 comments No comments