Queries for the ACSEmailStatusUpdateOperational table

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

Email failed deliveries by recipient ID

List recipients and failed delivery status.

ACSEmailStatusUpdateOperational
| where isnotempty(RecipientId)
| where DeliveryStatus != "Delivered"
| limit 100

Email Failed Deliveries by Message Id

List message ids and failed status.

ACSEmailStatusUpdateOperational
| where isempty(RecipientId) 
| where DeliveryStatus != "OutForDelivery"
| limit 100

Email Bounced and Suppressed Recipients

List recipients that have been dropped due to a hard bounce or suppressed due to customer managed opt-outs.

ACSEmailStatusUpdateOperational
| where DeliveryStatus == "Bounced" or DeliveryStatus == "Suppressed"
| where CorrelationId == "<email-send-request-message-id>"
| limit 100