Meeting Room Statistics

%3CLINGO-SUB%20id%3D%22lingo-sub-339779%22%20slang%3D%22en-US%22%3EMeeting%20Room%20Statistics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339779%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20wondering%20if%20there%20is%20a%20way%20to%20get%20any%20type%20of%20statistics%20on%20our%20meeting%20rooms%3F%20We%20have%20a%20good%20number%20of%20conference%20room%20resources%20and%20would%20like%20to%20see%20some%20data%20that%20would%20show%20how%20one%20room%20is%20being%20booked%20more%20often%20than%20another.%20Are%20there%20any%20reports%20or%20Powershell%20commands%20that%20can%20be%20run%20to%20achieve%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-339779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExchange%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339874%22%20slang%3D%22en-US%22%3ERe%3A%20Meeting%20Room%20Statistics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339874%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20need%20just%20the%20%22count%22%20of%20meetings%2C%20you%20can%20do%20a%20Search-Mailbox%20query%20against%20the%20room%20mailboxes%20in%20question%20and%20tally%20the%20results.%20If%20you%20want%20a%20proper%20report%20with%20duration%2C%20participants%20and%20whatnot%2C%20the%20only%20way%20to%20get%20such%20is%20via%20EWS%2C%20and%20there's%20a%20sample%20code%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F10921563%2Fextract-the-report-of-room-calendar-from-exchage-server-using-powershell-scripti%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F10921563%2Fextract-the-report-of-room-calendar-from-exchage-server-using-powershell-scripti%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339832%22%20slang%3D%22en-US%22%3ERe%3A%20Meeting%20Room%20Statistics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339832%22%20slang%3D%22en-US%22%3EI%E2%80%99ve%20seen%20a%20few%20powershell%20scripts%20out%20there%2C%20but%20can%E2%80%99t%20tell%20if%20they%20work%2C%20or%20work%20with%20ex%20online!%3CBR%20%2F%3EThere%20are%20third%20party%20systems%20also%20doing%20this%20as%20well!%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20are%20a%20uservoice%20for%20this%20too%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Foffice365.uservoice.com%2Fforums%2F273493-office-365-admin%2Fsuggestions%2F15876075-meeting-room-usage-statistics-and-reports%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Foffice365.uservoice.com%2Fforums%2F273493-office-365-admin%2Fsuggestions%2F15876075-meeting-room-usage-statistics-and-reports%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-734748%22%20slang%3D%22en-US%22%3ERe%3A%20Meeting%20Room%20Statistics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-734748%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%26nbsp%3Bthis%20out%20%22%3CA%20href%3D%22http%3A%2F%2Fwww.zoapi.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.zoapi.com%3C%2FA%3E%22%20It%20provides%20meeting%20room%20usage%20data%20-%20Overbooked%2FUnderbooked%2C%20Total%20%23%20of%20meetings%2C%20Longest%20meeting%2C%20Total%20used%20time%20%26amp%3B%20detailed%20report%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F284431%22%20target%3D%22_blank%22%3E%40garyleung1981%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-987118%22%20slang%3D%22en-US%22%3ERe%3A%20Meeting%20Room%20Statistics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-987118%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F58%22%20target%3D%22_blank%22%3E%40Vasil%20Michev%3C%2FA%3E%26nbsp%3B%20Is%20there%20any%20sample%20script%20for%20exchange%20online%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I was wondering if there is a way to get any type of statistics on our meeting rooms? We have a good number of conference room resources and would like to see some data that would show how one room is being booked more often than another. Are there any reports or Powershell commands that can be run to achieve this?

3 Replies
Highlighted
I’ve seen a few powershell scripts out there, but can’t tell if they work, or work with ex online!
There are third party systems also doing this as well!

There are a uservoice for this too:

https://office365.uservoice.com/forums/273493-office-365-admin/suggestions/15876075-meeting-room-usa...

Adam
Highlighted

If you need just the "count" of meetings, you can do a Search-Mailbox query against the room mailboxes in question and tally the results. If you want a proper report with duration, participants and whatnot, the only way to get such is via EWS, and there's a sample code here: https://stackoverflow.com/questions/10921563/extract-the-report-of-room-calendar-from-exchage-server...

Highlighted

@Vasil Michev  Is there any sample script for exchange online ?