Delen via

Query's voor de tabel AegDeliveryFailureLogs

  • Artikel

Zie de zelfstudie over Log Analytics voor meer informatie over het gebruik van deze query's in Azure Portal. Zie Query voor de REST API.

Bezorgingsfouten per onderwerp en fout

Logboeken met bezorgingsfouten per onderwerpnaam en foutbericht.

AegDeliveryFailureLogs 
| parse Message with * ", httpStatusCode=" HttpStatusCode "," * "., errorMessage=" ErrorMessage "," *
| parse _ResourceId with * "/topics/" TopicName 
| summarize by _ResourceId, TopicName, ErrorMessage

Bezorgingsfouten per onderwerp en fout

Logboeken met bezorgingsfouten per onderwerpnaam en foutbericht.

// To create an alert for this query, click '+ New alert rule'
AegDeliveryFailureLogs 
| parse Message with * ", httpStatusCode=" HttpStatusCode "," * "., errorMessage=" ErrorMessage "," *
| parse _ResourceId with * "/topics/" TopicName 
| summarize by _ResourceId, TopicName, ErrorMessage

Bezorgingsfouten per domein en fout

Logboeken met bezorgingsfouten per domeinnaam en foutbericht.

// To create an alert for this query, click '+ New alert rule'
AegDeliveryFailureLogs 
| parse Message with * ", httpStatusCode=" HttpStatusCode "," * "., errorMessage=" ErrorMessage "," *
| parse _ResourceId with * "/domains/" DomainName 
| project TimeGenerated, _ResourceId, DomainName, TenantId, EventSubscriptionName, SubResourceName, OperationName, HttpStatusCode, ErrorMessage
| summarize by _ResourceId, DomainName, SubResourceName, EventSubscriptionName, ErrorMessage

Onderwerpen Gemiddelde leveringslatentie

Gemiddelde leveringslatentie samengevat op onderwerpen, gebeurtenisabonnementen.

AegDeliveryFailureLogs
| parse _ResourceId with * "/topics/" TopicName
| where TopicName!= "" // and TopicName == "YOUR_TOPIC_NAME"
| parse Message with * ", latencyInMs=" LatencyInMilliSecond "," *
| summarize AverageDeliveryLatencyInMs = avg(todouble(LatencyInMilliSecond)) by TopicName, EventSubscriptionName
// Uncomment to filter for a specific Topic Name

Gemiddelde bezorgingslatentie voor domeinen

Gemiddelde leveringslatentie samengevat door domeinen, gebeurtenisabonnementen en SubResourceName.

AegDeliveryFailureLogs
| parse _ResourceId with * "/domains/" DomainName
| where DomainName != "" // and DomainName == "YOUR_DOMAIN_NAME"
| parse Message with * ", latencyInMs=" LatencyInMilliSecond "," *
| summarize AverageDeliveryLatencyInMs = avg(todouble(LatencyInMilliSecond)) by DomainName, EventSubscriptionName, SubResourceName
// Uncomment to filter by a specific Domain Name