Forum Discussion
Andrew-2000
Aug 24, 2021Copper Contributor
Microsoft Teams Rooms Reporting
We need to report the usage of our Microsoft Teams Rooms (MTRoW and MTRoA). Is there any possibility to get the Microsoft Teams Meeting participant count from all Teams Rooms from the last 30 Days? I would appreciate any help or tips.
- Yeah, those platforms seem to be more robust currently (specifically speaking of XiO as it's what I have experience with). But getting creative with the Teams Admin Center data also doesn't incur any additional costs, so that's the benefit for some.
- Nick59Copper ContributorI am pulling my hairs trying to figure that out as well. TAC and Pro portal both have the all the information, but neither one provides the ability to export the information to excel or CSV format, so you could pull it into power bi and create your own utilization report.
- Andrew-2000Copper ContributorThanks for your replies! One thing that comes to my mind is a custom powerbi report within M365 usage analytics. But i haven't tried it yet.
- RayGentryBrass ContributorThat's what I'm playing around with currently. I'm new to PowerBI though so it's slow going.
- Andrew-2000Copper Contributormy latest idea: I'm trying to add a fake department attribute to all MTR accounts, perhaps this will allow me to report the meeting participant count in the M365 usage analytics reports.
- Harald_SteindlIron ContributorDepending on the MTR hardware installed you might have better luck at their monitoring platforms. So, for Crestron that would be Fusion or XIO-Cloud, for Logi it would be Sync and so on...
- RayGentryBrass ContributorYeah, those platforms seem to be more robust currently (specifically speaking of XiO as it's what I have experience with). But getting creative with the Teams Admin Center data also doesn't incur any additional costs, so that's the benefit for some.
- RayGentryBrass ContributorAs far as I've seen, there isn't a way to pull a report that just shows Teams Rooms (which is a bit baffling in my opinion). You'll need to pull a User Activity report and filter it to see the Teams Rooms. Hopefully you used a standard naming convention for those accounts!
- jason_NguyenCopper ContributorI have tried it. But the "User activity report" doesn't have any Teams room's information. So, we could not filter it. Maybe we have to find another solution.
Thanks for your suggestion.