Queries for the ASRReplicatedItems table

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

Get replication health status history

Get replication health status history for a virtual machine.

let replicatedItemFriendlyName = "<insert your replicated item friendly name>";
ASRReplicatedItems
//| where TimeGenerated >= ago(30d) // uncomment this line to view last 30 days
//| where _ResourceId == resourceId // uncomment this line and enter resource ID
| where ReplicatedItemFriendlyName == replicatedItemFriendlyName
| project Day=startofday(TimeGenerated), TimeGenerated, ReplicatedItemId, ReplicatedItemFriendlyName, ReplicationStatus
| summarize arg_max(TimeGenerated,*) by Day