Queries for the ACSCallAutomationMediaSummary table
For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
Loop play success rate
Calculates the number of success and failures of the play operation when played in loop or not.
ACSCallAutomationMediaSummary
| where OperationName == "Play"
| summarize playedInLoopCount=count() by PlayInLoop, ResultType
Play to participant success rate
Calculates the number of success and failures of the play operation when played to a participant or to all.
ACSCallAutomationMediaSummary
| where OperationName == "Play"
| summarize playedToCount=count() by PlayToParticipant, ResultType
Recognize success rate
Calculates the number of success and failures of the recognize operation.
ACSCallAutomationMediaSummary
| where OperationName == "Recognize"
| summarize recognizeCount=count() by ResultType
Success rate by sub operation name
Calculates the number of success and failures of the recognize operation based on its sub operation name.
ACSCallAutomationIncomingOperations
| join ACSCallAutomationMediaSummary on OperationId
| where OperationName == "Recognize"
| summarize recognizeCount=count() by SubOperationName, ResultType1
| project SubOperationName, EventResultType = ResultType1, recognizeCount