storage accounts hot ,cold

If you need a table showing how much data is stored in Hot, Cool, Cold and Archive tiers across storage accounts, Azure Blob Inventory is a good option.

Enable Blob Inventory on the storage accounts and include properties such as blob name, size and access tier. Azure generates the inventory as CSV or Parquet, which you can then query with Synapse, Databricks, Fabric or even Power BI to create a table like:

This is preferable to manually checking each blob because Blob Inventory can provide tier distribution and other blob properties at scale.

If you only need the default access tier of each storage account, you can query the storage account properties through Azure CLI/PowerShell, but note that this does not necessarily represent the actual tier of every blob, since individual blobs can have their own explicitly assigned tier.

In Azure, getting this information depends on whether you want a summary of the actual data capacity stored in each tier across your accounts, or if you need a literal CSV table of every blob and its assigned tier.

Here are the three best ways to extract this information into a table format based on what you need.

Method 1: View Data Capacity by Tier (Azure Monitor Insights)

If you want a tabular report showing how much data (in GB/TB) is sitting in the Hot, Cool, Cold, and Archive tiers for each storage account, use built-in Azure Monitor Insights.

Navigate to Azure Monitor in the Azure Portal.

Under the Insights menu on the left, select Storage Accounts.

Click on the Capacity tab at the top.

Scroll down to the Capacity by Access Tier table. This will list all your storage accounts alongside the total data capacity currently residing in Hot, Cool, Cold, and Archive tiers.

You can click the Export to Excel icon at the top of the table to download it.

Method 2: Generate a CSV Table of All Blobs & Tiers (Storage Inventory)

If you need a line-by-line table detailing every individual blob and which tier it is currently stored in, you need to configure an Azure Storage Inventory rule.

Go to your specific Storage Account in the Azure portal.

Under Data management on the left menu, click Storage inventory.

Click Add your first inventory rule (or Add rule).

Name the rule and set the Object Type to Blob.

In the Inventory fields selection, ensure that Access Tier is checked.

1. Save the rule. Azure will generate a .csv or .parquet table daily in a specified container, giving you a complete audit of your tier data.In Azure, getting this information depends on whether you want a summary of the actual data capacity stored in each tier across your accounts, or if you need a literal CSV table of every blob and its assigned tier.