PSTN Call Statistics via Microsoft Graph API or PowerShell

%3CLINGO-SUB%20id%3D%22lingo-sub-97559%22%20slang%3D%22en-US%22%3EPSTN%20Call%20Statistics%20via%20Microsoft%20Graph%20API%20or%20PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-97559%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning.%3C%2FP%3E%3CP%3EThis%20discussion%20is%20related%20to%20obtaining%20SfB%20PSTN%20call%20statistics%20via%20some%20non%20GUI%20based%20source.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20using%20the%20SfBActivity%20%26gt%3B%20Detail%20report%20source%5Cmethod%2C%20the%20.CSV%20returned%20does%20not%20include%20any%20PSTN%20call%20statistics.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fgraph%2Fdocs%2Fapi-reference%2Fbeta%2Fapi%2Freportroot_sfbactivity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fgraph%2Fdocs%2Fapi-reference%2Fbeta%2Fapi%2Freportroot_sfbactivity%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20appears%20every%20access%20method%20to%20obtain%26nbsp%3BPSTN%20call%20data%20has%20been%20left%20out%20other%20than%20the%20report%20GUI%20seen%20at%20either%20of%20these%20two%20locations%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fadminportal.services.skypeforbusiness.com%2Fanalytics%2Fhome%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fadminportal.services.skypeforbusiness.com%2Fanalytics%2Fhome%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fadmin0a.online.lync.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fadmin0a.online.lync.com%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20provide%20information%20on%20the%20developement%20status%20or%20the%20SfB%20roadmap%20for%20advance%20reporting%20in%20Microsoft%20Graph%20API%26nbsp%3Bor%20PowerShell%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20company%20would%20like%20to%20convert%20completely%20to%20SfB%20but%20the%20inability%20to%20export%20the%20call%20logs%20programmatically%20is%20a%20roadblock.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EIs%20this%20something%20that's%20currently%20in-scope%20for%20development%20and%20if%20so%20how%20can%20I%20track%20the%20status%20and%20release%20information%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20was%20working%20originally%20in%20PowerShell%20using%20the%20%22Get-CsPSTNUsageDetailReport%22%20cmdlet%20but%20that%20cmdlet%20has%20been%20deprecated%20and%26nbsp%3Bwill%20no%20longer%26nbsp%3Bretrieve%20current%26nbsp%3B%5C%20new%20records%20and%20now%20we're%20left%20without%20a%20way%20to%20pull%20PSTN%20data%20from%20SfB%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENAME%3CBR%20%2F%3EGet-CsPSTNUsageDetailReport%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3ESYNOPSIS%3CBR%20%2F%3EThis%20cmdlet%20is%20available%20only%20in%20the%20cloud-based%20service.%3CBR%20%2F%3E%3CSTRONG%3EThis%20cmdlet%20is%20still%20available%2C%20but%20it%20no%20longer%20gives%20accurate%20results.%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-97559%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMonitoring%20%26amp%3B%20Reporting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPSTN%20Calling%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-253766%22%20slang%3D%22en-US%22%3ERe%3A%20PSTN%20Call%20Statistics%20via%20Microsoft%20Graph%20API%20or%20PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253766%22%20slang%3D%22en-US%22%3EWe%20also%20need%20this%20information%20for%20call%20reports%20and%20stats.%20Unlike%20many%20other%20missing%20features%2C%20this%20doesn't%20seem%20to%20be%20acknowledged%20in%20any%20roadmaps.%20It's%20a%20requirement%20to%20provide%20metrics%20and%20analytics%20on%20call%20information%2C%20and%20the%20reports%20that%20you%20can%20download%20from%20the%20old%20SfB%20admin%20panel%20are%20pretty%20much%20unusable%20-%20you%20have%20to%20manually%20download%2C%20unzip%2C%20convert%20the%20document%20from%20tab%20delimited%20and%20then%20try%20to%20make%20sense%20of%20it.%20For%20a%20weekly%20call%20report%20it's%20just%20not%20plausible.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251435%22%20slang%3D%22en-US%22%3ERe%3A%20PSTN%20Call%20Statistics%20via%20Microsoft%20Graph%20API%20or%20PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251435%22%20slang%3D%22en-US%22%3ELooking%20for%20the%20same.%20Could%20we%20get%20an%20official%20response%20from%20Microsoft%20on%20this%3F%20Presently%20there%20is%20no%20way%20to%20automate%20this%20process%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-240558%22%20slang%3D%22en-US%22%3ERe%3A%20PSTN%20Call%20Statistics%20via%20Microsoft%20Graph%20API%20or%20PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240558%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20also%20interested%20in%20this%20as%20it%20appears%20to%20be%20a%20quite%20manual%20process%20right%20now%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216748%22%20slang%3D%22en-US%22%3ERe%3A%20PSTN%20Call%20Statistics%20via%20Microsoft%20Graph%20API%20or%20PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216748%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20also%20wondering%20about%20this..%26nbsp%3B%20I%20am%20working%20on%20reporting%20in%20SfBO%20via%20PS%2C%20and%20it%20doesn't%20look%20like%20they%20have%20built%20out%20the%20Graph%20API%20pieces%20for%20this%20to%20work.%26nbsp%3B%26nbsp%3B%40MS%20is%20there%20any%20updates%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191211%22%20slang%3D%22en-US%22%3ERe%3A%20PSTN%20Call%20Statistics%20via%20Microsoft%20Graph%20API%20or%20PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191211%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20in%20the%20same%20situation.%20We%20need%20the%20data%20to%20create%20detailed%20custom%20Teams%26amp%3BSFB%20reports%20but%20can't%20find%20a%20way%20to%20access%20it%20programmatically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3EGeorge%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191041%22%20slang%3D%22en-US%22%3ERe%3A%20PSTN%20Call%20Statistics%20via%20Microsoft%20Graph%20API%20or%20PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191041%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3Ewe%20also%20need%20to%20get%20answers%20about%20this%20topic.%3C%2FP%3E%3CP%3EMicrosoft%20any%20reaction%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebest%20regards%2C%3C%2FP%3E%3CP%3EMarkus%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Good morning.

This discussion is related to obtaining SfB PSTN call statistics via some non GUI based source.

 

When using the SfBActivity > Detail report source\method, the .CSV returned does not include any PSTN call statistics.
https://developer.microsoft.com/en-us/graph/docs/api-reference/beta/api/reportroot_sfbactivity

 

It appears every access method to obtain PSTN call data has been left out other than the report GUI seen at either of these two locations:
https://adminportal.services.skypeforbusiness.com/analytics/home
https://admin0a.online.lync.com

 

Can someone provide information on the developement status or the SfB roadmap for advance reporting in Microsoft Graph API or PowerShell?

 

Our company would like to convert completely to SfB but the inability to export the call logs programmatically is a roadblock.

 

Is this something that's currently in-scope for development and if so how can I track the status and release information?

 

It was working originally in PowerShell using the "Get-CsPSTNUsageDetailReport" cmdlet but that cmdlet has been deprecated and will no longer retrieve current \ new records and now we're left without a way to pull PSTN data from SfB Online.

 

NAME
Get-CsPSTNUsageDetailReport

 

SYNOPSIS
This cmdlet is available only in the cloud-based service.
This cmdlet is still available, but it no longer gives accurate results.

6 Replies

Hi,

we also need to get answers about this topic.

Microsoft any reaction?

 

best regards,

Markus

Hi,

 

We are in the same situation. We need the data to create detailed custom Teams&SFB reports but can't find a way to access it programmatically.

 

Greetings,

George

I am also wondering about this..  I am working on reporting in SfBO via PS, and it doesn't look like they have built out the Graph API pieces for this to work.  @MS is there any updates?

We are also interested in this as it appears to be a quite manual process right now

Looking for the same. Could we get an official response from Microsoft on this? Presently there is no way to automate this process
We also need this information for call reports and stats. Unlike many other missing features, this doesn't seem to be acknowledged in any roadmaps. It's a requirement to provide metrics and analytics on call information, and the reports that you can download from the old SfB admin panel are pretty much unusable - you have to manually download, unzip, convert the document from tab delimited and then try to make sense of it. For a weekly call report it's just not plausible.