Currently usage reports of Teams are good, our use case will include calculating the ROI for users having remote meetings and not physical ones.
Would like to be able to export the info available via the users dashboard into a list of conferences and participants the user has had meetings with for the last 7 or 30 days.
At the moment there is no API access to meeting information as it is, the CQD modules or BI connectors will not provide this information.
We would like to see by Organizer UPN, the conference Ids, duration and participants list. We can obtain the total numbers, but not a detailed view.


Global User Usage Report:
Id, DisplayName, UserName, ChannelMessages, ReplyMessages, PostMessages, ChatMessages, UrgentMessages, MeetingsOrganizedScheduledOneTime, MeetingsOrganizedScheduledRecurring, MeetingsOrganizedAdhoc, TotalMeetingsOrganized, MeetingsParticipatedScheduledOneTime, MeetingsParticipatedScheduledRecurring, MeetingsParticipatedAdhoc, TotalMeetingsParticipated, 1:1 Calls, AudioTime (Minutes), VideoTime (Minutes), ScreenShareTime (Minutes), LastActivity (UTC Time), OtherActivity
"d219f492-xxxx-xxxx-a5ed-05a245633930,"User Display Name",user@domain.com,0,0,0,22,0,2,0,0,2,10,0,0,10,0,353,352,0,"2021-02-24T11:01:05Z",No
Desired Report:
User UPN, DisplayName, Meeting ID, Start time, Participants, Participants UPNs, Duration, Activity type, Client, Audio quality
User@domain.com, “USER NAME”, “0215d237-0c4a-450d-872c-xxxxxxxx1566”, “Feb 25, 2021, 11:59 AM GMT+1”,12,”participant1@domain.com; ...; participant12@domain.com”, 01:07:55, “Conference.”, “Microsoft Teams”, “Good”
Is this something anybody has managed to achieve?
Tried:
CQD PowerShell:
https://psg-prod-centralus.cloudapp.net/packages/CQDPowerShell/2.0.1
API GRAPH:
https://docs.microsoft.com/es-es/graph/api/resources/callrecords-api-overview?view=graph-rest-beta
Thanks in advance