SOLVED

Microsoft Teams Rooms Reporting

%3CLINGO-SUB%20id%3D%22lingo-sub-2679215%22%20slang%3D%22en-US%22%3EMicrosoft%20Teams%20Rooms%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2679215%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20need%20to%20report%20the%20usage%20of%20our%20Microsoft%20Teams%20Rooms%20(MTRoW%20and%20MTRoA).%20Is%20there%20any%20possibility%20to%20get%20the%20Microsoft%20Teams%20Meeting%20participant%20count%20from%20%3CU%3Eall%3C%2FU%3E%20Teams%20Rooms%20from%20the%20last%2030%20Days%3F%26nbsp%3BI%20would%20appreciate%20any%20help%20or%20tips.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2679215%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%20Rooms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMTR%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMTRoA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMTRoW%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2679790%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Rooms%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2679790%22%20slang%3D%22en-US%22%3EAs%20far%20as%20I've%20seen%2C%20there%20isn't%20a%20way%20to%20pull%20a%20report%20that%20just%20shows%20Teams%20Rooms%20(which%20is%20a%20bit%20baffling%20in%20my%20opinion).%20You'll%20need%20to%20pull%20a%20User%20Activity%20report%20and%20filter%20it%20to%20see%20the%20Teams%20Rooms.%20Hopefully%20you%20used%20a%20standard%20naming%20convention%20for%20those%20accounts!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2682130%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Rooms%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2682130%22%20slang%3D%22en-US%22%3EDepending%20on%20the%20MTR%20hardware%20installed%20you%20might%20have%20better%20luck%20at%20their%20monitoring%20platforms.%20So%2C%20for%20Crestron%20that%20would%20be%20Fusion%20or%20XIO-Cloud%2C%20for%20Logi%20it%20would%20be%20Sync%20and%20so%20on...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2683262%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Rooms%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2683262%22%20slang%3D%22en-US%22%3EYeah%2C%20those%20platforms%20seem%20to%20be%20more%20robust%20currently%20(specifically%20speaking%20of%20XiO%20as%20it's%20what%20I%20have%20experience%20with).%20But%20getting%20creative%20with%20the%20Teams%20Admin%20Center%20data%20also%20doesn't%20incur%20any%20additional%20costs%2C%20so%20that's%20the%20benefit%20for%20some.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2683264%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Rooms%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2683264%22%20slang%3D%22en-US%22%3EThat's%20what%20I'm%20playing%20around%20with%20currently.%20I'm%20new%20to%20PowerBI%20though%20so%20it's%20slow%20going.%3C%2FLINGO-BODY%3E
New Contributor

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.

8 Replies
As 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!
Depending 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...
Thanks 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.
best response confirmed by ThereseSolimeno (Microsoft)
Solution
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.
That's what I'm playing around with currently. I'm new to PowerBI though so it's slow going.
my 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.
Let me know if that works - not that you should have to do it since the Teams Admin Center knows what accounts are for Teams Rooms. It's really crazy that MS didn't think people would want to look at Room Usage differently than personal usage LOL
I'm working in a large enterprise, it can take a few days (or weeks) to get the permission to add a new department value :) But i will post the results here