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 | [email protected] |
| 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.
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)
Thanks for your feedback 🙂
Andrew,
Is their a way to automate downloading these file’s??
PS or P-bi?
Bueller…..Bueller….Bueller???
Give this a go – https://github.com/leeford/Get-TeamsPSTNCallRecords. It uses the API so you will need to create an app registration.
hello Andrew a query is there a way to also automate voip calls?
Thanks a lot.
“Teams user activity” report should give you what you need. There is a 1:1 calls column.
Hello Andrew,
I’m wondering why my Shared Correlation ID isn’t showing up when I export my Microsoft Teams PSTN usage report to Excel. Can you help me understand why that might be happening?
Odd, not sure. The official MS docs still show that it exists. Do you use Direct Routing? Maybe it doesn’t exist unless you do.