Home

Exporting Meeting Call History to CSV/Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1038963%22%20slang%3D%22en-US%22%3EExporting%20Meeting%20Call%20History%20to%20CSV%2FExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1038963%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20get%20a%20dump%20of%20the%20data%20from%20Users%5Cusername%5Ccall%20history%20for%20a%20specific%20meeting%20and%20export%20it%20to%20CVS%2C%20for%20example%3F%20The%20data%20must%20be%20there%20somewhere%2C%20but%20how%20can%20I%20get%20at%20this%3F%20Via%20Power%20Shell%20maybe%3F%3C%2FP%3E%3CP%3EOn%20the%20page%20where%20it%20shows%20the%20breakdown%20of%20the%20meeting%20detials%20it%20displays%3A%3C%2FP%3E%3CP%3ESession%20start%20time%3CBR%20%2F%3EParticipant%3CBR%20%2F%3ESession%20type%3CBR%20%2F%3EDuration%3C%2FP%3E%3CP%3EAudio%20Quality%3C%2FP%3E%3CP%3Ebut%20there%20is%20no%20way%20to%20export%20this%20on%20the%20page%20it%20seems.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1038963%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECall%20History%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EReports%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1041991%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20Meeting%20Call%20History%20to%20CSV%2FExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1041991%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20if%20this%20is%20possible%20or%20is%20it%20just%20a%20limitation%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20no%20way%20to%20get%20at%20the%20data%20via%20Graph%20API%2C%20for%20example%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1042156%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20Meeting%20Call%20History%20to%20CSV%2FExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1042156%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111873%22%20target%3D%22_blank%22%3E%40craig%20taylor%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20too%20have%20started%20looking%20for%20something%20similar%20(to%20help%20in%20troubleshooting%20some%20pesky%20conference%20room%20meetings).%20This%20thread%20might%20prove%20somewhat%20helpful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Teams%2FInfo-on-Monitoring-and-Reporting-Teams-audio-video-calls-Call%2Fm-p%2F91938%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Teams%2FInfo-on-Monitoring-and-Reporting-Teams-audio-video-calls-Call%2Fm-p%2F91938%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20post%20here%20if%20I%20find%20(or%20develop)%20anything%20concrete!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1043628%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20Meeting%20Call%20History%20to%20CSV%2FExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1043628%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F238450%22%20target%3D%22_blank%22%3E%40Steven%20Adamo%3C%2FA%3E%26nbsp%3BHi%20Steven%2C%20I%20have%20been%20able%20to%20cobble%20something%20together%20by%20using%20the%20csusersession%20cmdlet%20and%20the%20Skype%20for%20Business%20Online%20PSTN%20usage%20report%20in%20the%20SfB%20Legacy%20portable.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShould%20the%20csusersession%20be%20able%20to%20provide%20details%20on%20the%20attendees%20that%20used%20the%20dial-in%20number%3F%20It%20only%20seems%20to%20give%20you%20information%20on%20who%20dialed%20into%20the%20meeting%20via%20their%20sip%20account.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Is it possible to get a dump of the data from Users\username\call history for a specific meeting and export it to CVS, for example? The data must be there somewhere, but how can I get at this? Via Power Shell maybe?

On the page where it shows the breakdown of the meeting detials it displays:

Session start time
Participant
Session type
Duration

Audio Quality

but there is no way to export this on the page it seems.

3 Replies
Highlighted

Does anyone know if this is possible or is it just a limitation?

 

Is there no way to get at the data via Graph API, for example?

Highlighted

Hi @craig taylor ,

 

I too have started looking for something similar (to help in troubleshooting some pesky conference room meetings). This thread might prove somewhat helpful.

 

https://techcommunity.microsoft.com/t5/Microsoft-Teams/Info-on-Monitoring-and-Reporting-Teams-audio-...

 

I'll post here if I find (or develop) anything concrete! :)

Highlighted

@Steven Adamo Hi Steven, I have been able to cobble something together by using the csusersession cmdlet and the Skype for Business Online PSTN usage report in the SfB Legacy portable.

 

Should the csusersession be able to provide details on the attendees that used the dial-in number? It only seems to give you information on who dialed into the meeting via their sip account.

Related Conversations
AREA CODE
ATurner876 in Excel on
0 Replies
Excel if function
Shelbi_kay10 in Excel on
0 Replies
Troubleshooting a published Excel formula
mlmat184 in Excel on
7 Replies
Freezing panes
KamJones in Excel on
2 Replies
How can I extract URL from hyperlinks?
tachyglossus in Excel on
2 Replies