Queries for the ACSRoomsIncomingOperations table

Rooms operational errors

List rooms error ordered by recency.

ACSRoomsIncomingOperations
| where ResultType == "Failed"
| project TimeGenerated, OperationName, OperationVersion, ResultSignature
| order by TimeGenerated desc
| limit 100

Rooms operation result counts

For every rooms operation, count the types of returned results.

ACSRoomsIncomingOperations
| summarize Count = count() by OperationName, OperationVersion, ResultType, ResultSignature
| order by OperationName asc, Count desc

Rooms operation summary

The average statistics of room properties such as participants count for operation version 2023-03-31-preview.

ACSRoomsIncomingOperations
// where OperationName == "<operation>" // This can be uncommented and specified to calculate only a single operation's duration percentiles
| where OperationVersion == "2023-10-30-preview"
| summarize TotalRoomCount = dcount(RoomId),
            AvgAddedParticipantsCount = avg(AddedRoomParticipantsCount),
            AvgRemovedParticipantsCount = avg(RemovedRoomParticipantsCount),
            AvgUpsertedParticipantsCount = avg(UpsertedRoomParticipantsCount),
            AvgRoomLifespan = avg(RoomLifespan),
            AvgPstnDialOutEnabled = avg(PstnDialOutEnabled)