Queries for the AddonAzureBackupStorage table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Trend of total Cloud Storage consumed

View the daily trend of total (cumulative) Cloud Storage consumed.

// To create an alert for this query, click '+ New alert rule'
AddonAzureBackupStorage
| where OperationName == "StorageAssociation"
//Get total Cloud Storage being consumed per Backup Item at the end of each day
| summarize TotalStoragePerBackupItemPerDay=sum(StorageConsumedInMBs) by BackupItemUniqueId, Day=bin(TimeGenerated,1d), ResourceId
//Get total Cloud Storage being consumed at the end of each day
| summarize TotalStorage=sum(TotalStoragePerBackupItemPerDay) by Day, ResourceId
| sort by Day asc
| render timechart