Microsoft Teams PSTN usage report

The Teams PSTN usage report in the Microsoft Teams admin center gives you an overview of calling and audio conferencing activity in your organization. You can view detailed calling activity for Calling Plans if you use Microsoft as your telephony carrier and for Direct Routing if you use your own telephony carrier.

The Calling Plans tab shows information including the number of minutes that users spent in inbound and outbound PSTN calls and the cost of these calls. The Direct Routing tab shows you information including the SIP address and call start and end times. Use the information in this report to gain insight into PSTN usage in your organization and help you to investigate, plan, and make business decisions.

View the report

  1. In the left navigation of the Microsoft Teams admin center, click Analytics & reports > Usage reports. On the View reports tab, under Report, select PSTN usage report.
  2. Under Date range, select a predefined range of 7 or 28 days, or set a custom range, and then select Run report.

Interpret the report

Calling Plans

Screenshot of the Calling Plans PSTN usage report report in the admin center

Callout Description
1 The report can be viewed for trends over the last 7 days, 28 days, or a custom date range that you set
2 Each report has a date for when it was generated. The reports usually reflect a 24 to 48 hour latency from time of activity.
3 The X axis is the selected date range for the specific report. The Y axis is the total number of calls over the selected time period.
Hover over the dot on a given date to see the total calls on that date.
4 The table gives you a breakdown of PSTN usage per call.
  • Time stamp (UTC) is the time the call started.
  • Display name is the display name of the user. You can click the display name to go to the user's setting page in the Microsoft Teams admin center.
  • Username is the user's sign in name.
  • Phone number is the number that received the call for inbound calls or the number dialed for outbound calls.
  • Call type is whether the call was a PSTN outbound or inbound call and the type of call such as a call placed by a user or an audio conference. The calls types you may see include:

    Teams user call types
    • user_in - the user received an inbound PSTN call.
    • user_out - the user placed an outbound PSTN call
    • user_out_conf - the user added two or more PSTN participants to the call such as a three-way conference call
    • user_out_transfer - the user transferred the call to a PSTN number
    • user_out_forwarding - the user forwarded the call to a PSTN number
    • conf_in - an inbound call to the Audio Conferencing bridge
    • conf_out - an outbound call from the Audio Conferencing bridge usually to add a PSTN number to the conference

    Teams bots call types
    • ucap_in - an inbound PSTN call to Teams bot such as auto attendant or call queue
    • ucap_out - an outbound PSTN call from a Teams bot such as auto attendant or call queue

  • Called to is the number dialed.
  • To country or region is the country or region dialed.
  • Called from is the number that placed the call.
  • From country or region is the country or region from where the call was placed.
  • Charge is the amount of money or cost of the call that's charged to your account.
  • Currency is the type of currency used to calculate the cost of the call.
  • Duration is how long the call was connected.
  • Domestic/International tells you whether the call was domestic (within a country or region) or international (outside a country or region) based on the user's location.
  • Call ID is the call ID for a call. It's a unique identifier for the call you can use when calling Microsoft Support.
  • Number type is the user's phone number type, such as a service of toll-free number.
  • Country or region is the usage location.
  • Conference ID is the conference ID of the audio conference.
  • Capability is the license used for the call. The license types you may see include:
    • MCOPSTNPP - Communications Credits
    • MCOPSTN1 - Domestic Calling Plan (3000 min US / 1200 min EU plans)
    • MCOPSTN2 - International Calling Plan
    • MCOPSTN5 - Domestic Calling Plan (120 min calling plan)
    • MCOPSTN6 - Domestic Calling Plan (240 min calling plan)
    • MCOMEETADD - Audio Conferencing
    • MCOMEETACPEA - Pay Per Minute Audio Conferencing
To see the information that you want in the table, make sure to add the columns to the table.
5 Select Edit columns to add or remove columns in the table.
6 Select Filter to filter the report by username or call type
7 Select Full screen to view the report in full screen mode.
8 You can export the report to a CSV file for offline analysis. Click Export to Excel, and then on the Downloads tab, click Download to download the report when it's ready.

Direct Routing

Screenshot of the Direct Routing PSTN usage report report in the admin center

Callout Description
1 The report can be viewed for trends over the last 7 days or 28 days.
2 Each report has a date for when it was generated. The reports usually reflect a 24 to 48 hour latency from time of activity.
3 The X axis is the selected date range for the specific report. The Y axis is the total number of calls over the selected time period.
Hover over the dot on a given date to see the total calls on that date.
4 The table gives you a breakdown of PSTN usage per call.
  • Time stamp (UTC) is the time the call started.
  • Display name is the display name of the user. You can click the display name to go to the user's settings page in the Microsoft Teams admin center. The name can also be the name of a bot, for example the Call Queue or Cloud Auto Attendant.
  • SIP address is the SIP address of the user or a bot who received or made the call.
  • Caller number is the number of the user or the bot who made the call.
  • >
  • Callee number is the number of the user or the bot who received the call. On an inbound call to a Teams user it will be the Teams user, on an outbound call from a Teams user it will be the PSTN User.
  • Call type is whether the call was a PSTN outbound or inbound call and the type of call such as a call placed by a user or an audio conference. The call types you may see include:

    Teams user call types
    • dr_in - the user received an inbound PSTN call
    • dr_out - the user placed an outbound PSTN call
    • dr_out_user_conf - the user added a PSTN participant to the call
    • user_out_transfer - the user transferred the call to a PSTN number
    • dr_out_user_forwarding - the user forwarded the call to a PSTN number
    • dr_out_user_transfer - the user transferred the call to a PSTN number
    • dr_emergency_out - the user made an emergency call

    Teams bots call types
    • dr_in_ucap - an inbound PSTN call to a Teams bot such as auto attendant or call queue
    • dr_out_ucap - an outbound PSTN call from a Teams bot such as auto attendant or call queue

  • Called to is the number of the user who received the call.
  • Start time (UTC) is the time when the SIP proxy received the final answer (SIP Message “200 OK”) from the SBC on an outbound call (Teams/Bot to a PSTN User), or after the SIP Proxy send the Invite to the next hop within the Teams backend on an inbound call (PSTN User to a Teams/Bot).
  • Invite time (UTC) is the time when the initial Invite was sent on an outbound call from a Teams user or bot call to the SBC, or received on an inbound call to a Teams or bot call by the SIP Proxy component of Direct Routing from the SBC.
  • Failure time (UTC) is the time the call failed. For failed calls only. Final SIP Code, Final Microsoft Subcode, and Final SIP Phrase provide the reasons why the call failed and can help with troubleshooting.
  • End time (UTC) is the time the call ended (for successful calls only).
  • Duration is how long the call was connected.
  • Number type is the user's phone number type, such as a service of toll-free number.
  • Media bypass indicates whether the trunk was enabled for media bypass.
  • SBC FQDN is the fully qualified domain name (FQDN) of the Session Border Controller (SBC).
  • Azure region for Media is the data center that was used as media path in a non-bypass call.
  • Azure region for Signaling is the data center that was used for signaling for both bypass and non-bypass calls.
  • Event type is the event type of the call. You'll see Success for successful calls and Attempt for failed calls.
  • Final SIP code is the code with which the call ended.
  • Final Microsoft subcode is a code that indicates specific actions that occurred.
  • Final SIP phrase is the description of the SIP code and Microsoft subcode.
  • Correlation ID is a unique identifier for the call that you can use when calling Microsoft Support.
  • Shared Correlation ID is only visible in the downloadable CSV file and does not exist in the portal. The shared correlation ID exists in at least two calls which are related. Please see detailed description below.
To see the information that you want in the table, make sure to add the columns to the table.
5 Select Edit columns to add or remove columns in the table.
6 Select Full screen to view the report in full screen mode.
7 Select Export to Excel to download the data in a comma separated file (CSV) for offline analysis or to use it as input for your billing system.

Caller/Callee fields considerations

Depending on the call direction, the Caller or Callee names can contain non-E164 numbers.

These fields can come from the customer SBC(s). There are three formats that the SBC can send to Direct Routing: E.164 numbers, non-E.164 numbers, and strings.

  • E.164 phone number from a user who has an E.164 number to a user who also has an E.164 number.
  • Call from a non-E.164 number. A user from a third-party PBX interconnected with Direct Routing makes a call to a Teams user. In this case, the caller number might be any non-E.164 number, for example +1001.
  • A spammer calls and doesn’t present a number, only a name, for example “Internal Revenue Service”. This string will be shown in the reports.

About Shared Correlation ID

The Shared Correlation ID only exists in the exported Excel file that you download and indicates that two or more calls are related. The following explains the different scenarios, and when Shared Correlation ID is present.

  1. PSTN User 1 on a PSTN endpoint called Teams User 1 on Teams client, call type Dr_In, correlation ID 57f28917-42k5-4c0c-9433-79734873f2ac, no shared correlation ID.
  2. Teams User 1 on Teams client called PSTN User 1 on a PSTN endpoint, call type Dr_Out 2c12b8ca-62eb-4c48-b68d-e451f518ff4, no shared correlation ID.
  3. PSTN User 1 on a PSTN endpoint called a Teams User 2 on Teams client, call type Dr_In f45e9a25-9f94-46e7-a457-84f5940efde9, shared correlation ID f45e9a25-9f94-46e7-a457-84f5940efde9.
  4. Existing call 3 with correlation ID “f45e9a25-9f94-46e7-a457-84f5940efde9”. PSTN User 1 in a call with Teams User 2. Teams User 2 transferred (blind or consultative) a call to Teams or PSTN User, call type Dr_Out_User_Transfer 45a1da7c-9e97-481a-8a05-3fe19a9a77e0, shared correlation ID f45e9a25-9f94-46e7-a457-84f5940efde9.