Queries for the CoreAzureBackup table

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

Backup Items by Vault and Backup item type

View the different types of items being backed up.

CoreAzureBackup
//get all backup items
| where OperationName == "BackupItem"
//remove duplicate records if any
| summarize arg_max(TimeGenerated, *) by BackupItemUniqueId, ResourceId
// summarize backup items by type
| summarize NumberOfItems=count(BackupItemUniqueId) by BackupItemType