May 23 2022 07:39 AM - edited May 23 2022 07:40 AM
Hi,
Does anybody knows how to export the CQD data to SQL server? I would like to take some statistics and keep them longer time than what Office 365 is offering by default.
May 23 2022 10:28 PM
May 24 2022 06:46 AM
Basically, Teams keeps the current CDRs only 30 days available. If you want to create any kind of statistics which are older than that, e.g. see PSTN calls, Queue reports, from last months, you should have access to that data longer then 30 days (e.g. for 365 days).
So the idea behind this was, to export available data from O365 and import that into e.g. SQL database. And then having e.g. Power BI templates for users.
This also solves even the bigger issue, to be able to read those CDRs from O365 you need to have quite much access to it which we cannot give for regular users. Having separated SQL DB we could segmenting what end users are able to see from their own calls. And that they can do using their own credentials.
On the Power BI we are able to use "Microsoft Call Quality" as a source, so I though using similar method. I could perhaps setup a process for doing the same in automatically, and importing the data into SQL. But before that I thought to ask from here, if anybody else has already been working with this.
May 25 2022 03:23 AM
@Petri X -Please have a look into this doc-Data and reports in Call Quality Dashboard (CQD) - Microsoft Teams | Microsoft Docs
May 27 2022 05:14 AM
May 27 2022 06:48 AM
Yes I did, but I was not sure how that should help? CQD user interface still requires extra credentials for viewers, and CQD does not have past year details.
If I success to do using e.g. PS script which collects the same data what Power BI does, then I could import that into SQL. Then I would be a bit closer to goal :)
May 28 2022 12:15 AM
May 30 2022 01:29 AM - edited May 30 2022 01:31 AM
@Petri X -Here is document - Use Power BI to analyze CQD data for Microsoft Teams - Microsoft Teams | Microsoft Docs
hope it helps.
May 30 2022 01:58 AM
Sorry to say @Sayali-MSFT, but that is still not help to reach the goal where I could do the same by scripting this.
But I believe the answer is, nobody has done this earlier :)
As far as I have seen, I should authenticate myself, and then send the query in JSON format. But obviously this requires more investigation :)
May 30 2022 05:54 AM
This is actually one finding:
The problem is, that is pretty old already, so not sure if this is active scenario anymore, or is the CQD actually not developed anymore. But this is till pretty interesting.