How to export User reports in MS teams using Powershell

Question

Hello

We are required to export user report for group of users. It should contain all meetings after 8 pm and meetings on weekends.

Our list of user is now over hundred.

Could you please suggest any way to obtain that information conveniently or by PowerShell?

Answer 1

Hello, according to this post you can use the script attached in the post to run the following reports:

• Export all Teams report
• All Teams members and owners report
• Member and owner report for a specific Team
• All Teams' owner report
• Export Teams' owner of a specific Team
• All Channels report
• List all channels in a specific Team
• List Channel's members and owner report

Microsoft Teams Reporting using PowerShell

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @IBN ,

We are required to export user report for group of users. It should contain all meetings after 8 pm and meetings on weekends.

I am afraid this is currently not feasible.

Normally, to view the meeting history data of a user, we can go to Teams admin center > Users > Manage Users, select the user, click the Meetings&Calls tab, scroll down and you would be able to see the list of past meetings and calls and use the filter to sort out all meetings:

However, as we can see from the meeting history page, currently there's no option available to export the entire list. A relevant feature request has already been submitted in the feedback portal for Microsoft Teams, see this link. I've already voted it and it's suggested to add your votes or comments there as well. Hopefully we can see this option added in a future update.

At present, within the features available, we can only export the individual meeting or call history by clicking on the meeting ID to open the details page, then click the Excel icon to export the information into a csv file, but this is far from your request which needs to export meeting history for a group of users.

As regards to your concern about other ways or Powershell, I've also tried searching a lot, but so far cannot find an alternative method or script for this specific requirement. So for the time being, I assume you may have to go through the meeting histories for each user, find the items you need, manually copy and paste into an excel file for your further analysis need.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.