Hi!How can i get any type of usage reports on our meeting rooms (room mailbox)? We have over 500 rooms in our organisation and i would like to know how much these rooms are booked, if some rooms isn't been used and if some are always fully booked, if they are more booked in January than in February etc. Is there any way i get statistics on this? Any good PS script, 3rd party apps or even better, is there an feature for this in Office 365 that i missed? Thanks!

There's nothing built-in in O365, but there are sample scripts available online that can generate such a report. Here's one: https://github.com/NunoFilipeMota/PublicScripts/blob/main/GetMeetingRoomStats_EWS.ps1

Meeting room usage reports | Microsoft Community Hub

VasilMichev
MVP
Jul 12, 2022
There's nothing built-in in O365, but there are sample scripts available online that can generate such a report. Here's one: https://github.com/NunoFilipeMota/PublicScripts/blob/main/GetMeetingRoomStats_EWS.ps1
- cparker510
  Copper Contributor
  Feb 23, 2023
  VasilMichev how would I run this script to do the report?
- harrywillsonofficial
  Copper Contributor
  Sep 11, 2024
  VasilMichev wrote:
  There's nothing built-in in O365, but there are sample scripts available online that can generate such a report. Here's one: https://github.com/NunoFilipeMota/PublicScripts/blob/main/GetMeetingRoomStats_EWS.ps1
  nice one
harrywillsonofficial
Copper Contributor
Sep 11, 2024
To track meeting room usage and generate reports on bookings, you can use PowerShell scripts or third-party tools to analyze Office 365 room mailbox data. Look into apps like Microsoft Power BI for detailed analytics, or explore Office 365's built-in reporting features for room utilization. For a Free SEO Audit Tool, effective reporting tools can help optimize resource allocation and identify trends in room usage.MarkusSten
TonyRedmond
MVP
Sep 16, 2024
Here's a script to get statistics for room mailboxes: https://practical365.com/report-room-mailbox-statistics/ and another to printg out weekly schedules for room mailboxes https://practical365.com/room-mailbox-weekly-schedule/. Between the two, you should be able to construct a script that meets your needs.

Forum Discussion

Meeting room usage reports