Microsoft Teams PSTN Call Detail Records with Direct Routing Support

I’ve been waiting for this one for a while – tenant wide reporting on PSTN calling minutes – commonly referred to as Call Detail Records. This feature was originally announced in the road map found here.

This new feature is available from the Analytics & reports section of the Teams admin center. The report is called “PSTN Usage”:

Running the report provides an output like the following – notice that you can choose between Direct Routing and Calling Plan calls, as well as export to CSV and apply filters and views to the data:

If you export to CSV you’ll get a lot more information about the call. Here is an example output of that data:

Column Example Data
CorrelationId BE4DA206-0920-4308-8764-E831B57D3E1A
SIP Address test1@domain.com
Display Name Test One
User country US
Invite time 2019-10-08T20:54:48.4420000Z
Start time 2019-10-08T20:54:58.7590000Z
Failure time
End time 2019-10-08T20:58:05.7590000Z
Duration (seconds) 187
Success Yes
Callee Number +649892****
Caller Number +642188****
Call type ByotOut
Azure region for Media ASSE
Azure region for Signaling ASEA
Final SIP code 0
Final Microsoft subcode 560000
Final SIP Phrase Q.850;cause=16;text=”NORMAL_CLEARING”
SBC FQDN ucgeek.sbc2.domain.com
Media bypass No
Shared correlation ID

 

In both outputs you will notice that the Callee and Caller numbers are partially blanked out. Apparently this is due to privacy concerns that don’t make a lot of sense to me. What phone system doesn’t allow you to view the actual numbers dialed?? I think the SIP address is more revealing, but oh well its better than nothing. If you’re really keen to know more about the numbers, apparently the Correlation ID’s can be used to marry up the call record to those of the SBC (if you’re a Direct Routing customer). But that’s going to be a hassle for most I’d guess.

More detail can be found here in the official documentation.

 

Andrew Morpeth
Andrew Morpethhttps://ucgeek.co/author/amorpeth/
Andrew is a Modern Workplace Consultant specialising in Microsoft technologies based in Auckland, New Zealand; Andrew is a Director and Professional Services Manager at Lucidity Cloud Services and a Microsoft MVP.

Related Articles

NZ to get native Microsoft Teams calling

New Zealand (NZ) is set to get native Microsoft Teams calling by July 2021 - this feature allows you to replace your telephony solution with Microsoft Teams. Microsoft Teams calling for NZ further reduces the barrier to using Microsoft Teams as a telephony replacement solution for New Zealand businesses.

Microsoft Teams Calling Options for Telephony Replacement

Microsoft Teams Calling provides telephony replacement capability that could replace your PABX or any other solution you may have. This article takes you through the options and when to use them, and the licencing you will require to activate this feature for your users.
00:13:43

Skype for Business Response Groups Made Easy

Call Flow Manager for Skype for Business and Lync makes creating and managing Response Groups easy! No more bouncing between interfaces to configure a simple call flow. Call Flow Manager brings all the functionality of the Response Group service into a single user interface

4 COMMENTS

  1. Hi Andrew,
    Very informative, thanks. FYI, I’m seeing some additional options now and can see the Caller and Callee numbers.
    PSTN and SMS (Preview)
    PSTN minute and SMS (Preview)

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Andrew Morpeth
Andrew Morpethhttps://ucgeek.co/author/amorpeth/
Andrew is a Modern Workplace Consultant specialising in Microsoft technologies based in Auckland, New Zealand; Andrew is a Director and Professional Services Manager at Lucidity Cloud Services and a Microsoft MVP.

Latest Articles

NZ to get native Microsoft Teams calling

New Zealand (NZ) is set to get native Microsoft Teams calling by July 2021 - this feature allows you to replace your telephony solution with Microsoft Teams. Microsoft Teams calling for NZ further reduces the barrier to using Microsoft Teams as a telephony replacement solution for New Zealand businesses.

Microsoft Teams Calling Options for Telephony Replacement

Microsoft Teams Calling provides telephony replacement capability that could replace your PABX or any other solution you may have. This article takes you through the options and when to use them, and the licencing you will require to activate this feature for your users.
00:13:43

Skype for Business Response Groups Made Easy

Call Flow Manager for Skype for Business and Lync makes creating and managing Response Groups easy! No more bouncing between interfaces to configure a simple call flow. Call Flow Manager brings all the functionality of the Response Group service into a single user interface
00:13:30

Office 365 Backup with Synology NAS

There are many reasons that you may want to back up your Office 365 data. The most common reasons I see are data sovereignty...

Microsoft 365 Feature Roundup Dec 2020

Feature Roundup Presentation Microsoft 365 key feature releases and announcements for June to December 2020, in an easy to digest PowerPoint format.