Getting Call Quality Data in near real time

%3CLINGO-SUB%20id%3D%22lingo-sub-353202%22%20slang%3D%22en-US%22%3EGetting%20Call%20Quality%20Data%20in%20near%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353202%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20am%20trying%20to%20get%20hold%20of%20call%20quality%20data%20as%20soon%20as%20possible%20after%20a%20call%20has%20finished%20via%20script.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20realize%20the%20CQD%20is%20delayed%20by%20a%20couple%20of%20days%20so%20thats%20not%20going%20to%20fit%20the%20need%2C%20but%20in%20the%20GUI%20when%20a%20call%20has%20finished%20its%20record%20appears%20just%20a%20few%20moments%20later%20for%20the%20user.%26nbsp%3B%20Can%20this%20be%20queried%20%3F%26nbsp%3B%20I%20can%20see%20a%20beta%20API%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fcall-get%3Fview%3Dgraph-rest-beta%23response%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fcall-get%3Fview%3Dgraph-rest-beta%23response%3C%2FA%3E%2C%20which%20looks%20like%20it%20might%20help%2C%20but%20you%20have%20to%20have%20the%20%7Bid%7D%20property%20of%20the%20call%2C%20and%20if%20you%20dont%20know%20this%20how%20can%20you%20query%20for%20it%20%3F%26nbsp%3B%20I%20can't%20see%20any%20other%20was%20of%20giving%20an%20input%20parameter%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eeg%26nbsp%3B%3CSPAN%3EGET%20%3CA%20href%3D%22https%3A%2F%2Fgraph.microsoft.com%2Fbeta%2Fapp%2Fcalls%2F%7Bid%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fbeta%2Fapp%2Fcalls%2F%7Bid%3C%2FA%3E%7D%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMIke%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-353202%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EActivity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdoption%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354534%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Call%20Quality%20Data%20in%20near%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354534%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Steve%2C%20thats%20really%20helpful.%26nbsp%3B%20I%20agree%20with%20both%2C%20I%20pinged%20steve%20on%20twitter%20and%20I%20see%20Ken%20is%20coming%20to%20the%20same%20conclusions.%26nbsp%3B%20Its%20a%20touch%20frustrating%20because%20the%20data%20clearly%20is%20there%20-%20it%20appears%20in%20call%20analytics%20just%20a%20few%20moments%20after%20the%20call%20-%20but%20we%20can't%20get%20to%20it.%26nbsp%3B%20Hopefully%20this%20will%20improve%20from%20MS.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354289%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Call%20Quality%20Data%20in%20near%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354289%22%20slang%3D%22en-US%22%3E%3CP%3EMVP%20Ken%20Lasso%20just%20blogged%20on%20this%20very%20subject%2C%20largely%20confirming%20what%20you've%20found%20...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fucken.blogspot.com%2F2019%2F02%2Fms-cloud-analytics-current-state.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fucken.blogspot.com%2F2019%2F02%2Fms-cloud-analytics-current-state.html%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354269%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Call%20Quality%20Data%20in%20near%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354269%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F283400%22%20target%3D%22_blank%22%3E%40MikeB1903%3C%2FA%3E%20It%20might%20be%20worth%20sending%20an%20email%20to%20the%20author%20of%20the%20script%2C%20Jason%2C%20he%20was%20very%20helpful%20when%20we%20were%20using%20this%20script%20to%20extra%20RMC%20data%20from%20Skype.%20I%20doubt%20anyone%20knows%20much%20more%20about%20using%20these%20APIs.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354212%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Call%20Quality%20Data%20in%20near%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354212%22%20slang%3D%22en-US%22%3EThanks%20Steve%20that%E2%80%99s%20been%20really%20interesting%2C%20the%20get-csusersession%20that%20it%E2%80%99s%20using%20to%20get%20the%20data%20does%20return%20information%20for%20teams%20but%20interestingly%20-%20and%20frustratingly%20-%20the%20call%20quality%20data%20record%20isn%E2%80%99t%20there%2C%20it%E2%80%99s%20empty%20every%20time.%20This%20is%20populated%20somewhere%20because%20the%20gui%20has%20it%20a%20few%20minutes%20after%20a%20call%20is%20finished.%20So%20either%20you%20can%20pull%20it%20from%20another%20cmdlet%20or%20we%20are%20waiting%20for%20an%20updated%20api.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353503%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Call%20Quality%20Data%20in%20near%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353503%22%20slang%3D%22en-US%22%3E%3CP%3EHere's%20an%20example%20PowerShell%20from%20the%20product%20team%20that%20will%20allow%20you%20to%20export%20call%20data%20for%20a%20time%20period%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.powershellgallery.com%2Fpackages%2FCxdCallData%2F1.2.4.2%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.powershellgallery.com%2Fpackages%2FCxdCallData%2F1.2.4.2%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EHTH%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1268389%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Call%20Quality%20Data%20in%20near%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1268389%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F178440%22%20target%3D%22_blank%22%3E%40Steven%20Collier%3C%2FA%3E%26nbsp%3B%20Do%20you%20know%20if%20there%20is%20way%20to%20get%20CQD%20from%20data%20API.%20Like%20using%20below%20query%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2F%3CPORTAL%3E%2FQoEDataService%2FRunQuery%3C%2FPORTAL%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20looking%20into%20this%20document%20and%20mainly%20for%20skype%20for%20business%202015.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fskypeforbusiness%2Fmanagement-tools%2Fcall-quality-dashboard%2Frun-query%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fskypeforbusiness%2Fmanagement-tools%2Fcall-quality-dashboard%2Frun-query%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20not%20able%20to%20figure%20out%20how%20i%20can%20login%20with%20service%20principle%20and%20then%20to%20make%20call%20for%20accessing%20the%20data.%20Because%20documentation%20is%20not%20referring%20any%20way%20of%20login.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi I am trying to get hold of call quality data as soon as possible after a call has finished via script.

 

I realize the CQD is delayed by a couple of days so thats not going to fit the need, but in the GUI when a call has finished its record appears just a few moments later for the user.  Can this be queried ?  I can see a beta API, https://docs.microsoft.com/en-us/graph/api/call-get?view=graph-rest-beta#response, which looks like it might help, but you have to have the {id} property of the call, and if you dont know this how can you query for it ?  I can't see any other was of giving an input parameter ?

 

eg GET https://graph.microsoft.com/beta/app/calls/{id}

 

 

thanks

 

MIke

 

6 Replies

Here's an example PowerShell from the product team that will allow you to export call data for a time period

 

https://www.powershellgallery.com/packages/CxdCallData/1.2.4.2

 

HTH

Thanks Steve that’s been really interesting, the get-csusersession that it’s using to get the data does return information for teams but interestingly - and frustratingly - the call quality data record isn’t there, it’s empty every time. This is populated somewhere because the gui has it a few minutes after a call is finished. So either you can pull it from another cmdlet or we are waiting for an updated api.

@MikeB1903 It might be worth sending an email to the author of the script, Jason, he was very helpful when we were using this script to extra RMC data from Skype. I doubt anyone knows much more about using these APIs.

MVP Ken Lasso just blogged on this very subject, largely confirming what you've found ...

 

https://ucken.blogspot.com/2019/02/ms-cloud-analytics-current-state.html

Thanks Steve, thats really helpful.  I agree with both, I pinged steve on twitter and I see Ken is coming to the same conclusions.  Its a touch frustrating because the data clearly is there - it appears in call analytics just a few moments after the call - but we can't get to it.  Hopefully this will improve from MS.

@Steven Collier  Do you know if there is way to get CQD from data API. Like using below query ?

 

https://<portal>/QoEDataService/RunQuery

 

I am looking into this document and mainly for skype for business 2015.

https://docs.microsoft.com/en-us/skypeforbusiness/management-tools/call-quality-dashboard/run-query

I am not able to figure out how i can login with service principle and then to make call for accessing the data. Because documentation is not referring any way of login.