Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

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

Feedback

Was this page helpful?

Additional resources

  • Last updated on