Microsoft Teams CDR Fields and Descriptions

banner image of tables for Microsoft Teams CDR Fields in blue

Microsoft Teams has become the global leader in communication platforms, offering powerful collaboration tools for chat, file sharing, and video/voice calls both internally and worldwide. To fully leverage this platform, organizations need deep insights into its usage and performance, which are provided through Call Detail Records (CDRs). While Teams offers native reporting, Expo XT UC Analytics expands on these capabilities by not only enhancing Teams' reporting but also extending analytics across multiple unified communications platforms

Microsoft Teams CDR Fact Tables

Below, we provide several tables with detailed description of the fields available from the Microsoft Teams CDR fact tables. These tables capture various aspects of caller activity, call quality performance, and overall Teams utilization, offering a wealth of information for analysis and optimization.

Common Dimensions and Measurements for Microsoft Teams CDR

Teams CDR Field Name Type Microsoft Teams Field Description
ConferenceId Text GUID - Call identifier
Date DateTime Date of call (UTC)
DialogId Text GUID - Call identifier
DocumentId Text GUID - Call identifier
Duration Whole Number Duration of call, in seconds
EndTime DateTime Time call ended (UTC)
FirstIsCaller Boolean First and Second endpoint classification
FirstUPN Text The user principal name (UPN) of the first endpoint's user
Hour Text Hour call started (UTC)
Minute Text Minute call started (UTC)
PSTNCallDuration Whole Number Duration of the call in PSTN minutes
PSTNCallType Text Internal/External - Call is coming from within or outside the tenant
PSTNConnectivityType1 Text CallingPlan or DirectRouting
Second Text Second call started (UTC)
SecondUPN Text The user principal name (UPN) of the second endpoint's user
TenantId Text Tenant ID
Timestamp DateTime Time record was written (UTC)
UserStartTimeUTC DateTime Time call started (UTC)


Auto Attendant Dimensions for Microsoft Teams CDR

Teams CDR Field Name Type Microsoft Teams Field Description
AutoAttendantCallFlow Text States of Auto Attendant call (e.g., abs_search, announcement)
AutoAttendantCallResult Text Final call result (e.g., failed_to_establish_media, service_declined)
AutoAttendantCallerActionCounts Whole Number Number of actions performed by the caller during the Auto Attendant call
AutoAttendantChainDurationInSecs Real Number Duration of the call in the Auto Attendant in seconds
AutoAttendantChainIndex Whole Number Chain index for calls involving multiple Auto Attendants
AutoAttendantChainStartTime DateTime Start time of the Auto Attendant call chain
AutoAttendantCount Whole Number Number of Auto Attendants involved in the call
AutoAttendantDirectorySearchMethod Text Method used to search the directory in the Auto Attendant (e.g., DTMF, voice)
AutoAttendantIdentity Text Resource account URI the call arrived on
AutoAttendantTransferAction Text Call transfer target type (e.g., AA, CQ, external_pstn)
HasAA Boolean Indicates if the call involved an Auto Attendant


Call Queue Dimensions

Teams CDR Field Name Type Microsoft Teams Field Description
CallQueueAgentCount Whole Number Number of agents in the Call queue
CallQueueAgentOptInCount Whole Number Number of agents opted-in to the Call queue
CallQueueCallResult Text Final state of the call in the Call queue (e.g., agent_joined_conference)
CallQueueDurationSeconds Real Number Duration of the call in the Call queue in seconds
CallQueueFinalStateAction Text Final action taken by the Call queue (e.g., disconnect, forward)
CallQueueIdentity Text Resource account URI the call arrived on
CallQueueTargetType Text Call redirection target type (e.g., ApplicationEndpoint, Mailbox)
HasCQ Boolean Indicates if the call involved a Call queue
TransferredFromCallQueueIdentity Text Resource account URI of the Call queue the call was transferred from


Call Quality Dashboard (CQD) Dimensions and Measurements

Teams CDR Field Name Type Microsoft Teams Field Description
AvgAutoAttendantChainDurationSeconds Real Number Average duration of calls in the Auto Attendant chain in seconds
AvgCallDuration Real Number Average duration of calls
AvgCallQueueDurationSeconds Real Number Average duration of calls in the Call queue in seconds
PSTNTotalMinutes Real Number Total minutes used in PSTN calls
TotalAudioStreamDuration Real Number Total duration of audio streams
TotalCallCount Whole Number Total number of calls


By leveraging these CDR fields and the advanced analytical capabilities of Expo XT UC Analytics, organizations can gain a deeper understanding of their Microsoft Teams usage, identify areas for improvement, and make data-driven decisions to enhance their unified communications infrastructure. For more information about the comprehensive analytics available for your entire communication network, including Microsoft Teams, explore the full capabilities of Expo XT UC Analytics for Teams.

cta banner with screenshot of Expo XT Analytics for Teams Phone