Room mailboxes have been available for a very long time now, and most organizations make extensive use of them for all their meeting room bookings. In certain cases, having statistical information about these rooms helps organizations plan or redesign their offices in a more efficient way. This information can show how often certain rooms are utilized, the average meeting duration, who tends to book more meetings, and so on.
In this article we will develop a script to provide us with some of this information and to serve as a stepping stone to gather further information depending on the reader’s particular needs. The end result will look something like this:
In this example, I only searched one meeting room called ITD – 16A – Small CF VC. For the month of December we can see that a total of 115 meetings were booked, out of which 55% are recurring meetings. The average meeting duration was 46 minutes, each meeting had an average of 8 attendees and there were slightly more meetings booked in the morning.
To download the script and the read the entire article, please go to MSExchange’s Exchange Meeting Room Statistics article page.
This article has been extremely helpful...thank you! I was wondering what the script line would be to search each conference room during specific periods of time. For example, I want to see all conference rooms from 01/01/2016 - 12/31/2016 from 0800 - 1700. We are interested in seeing how often rooms are utilized, Monday through Friday, during a typical 8 hour workday. Thank you so much!
ReplyDeleteGreat article! This article has been extremely helpful for our organization. I had a question...how would we search all conference rooms during specific times? For example, your script enables us to search by given days, weeks or months. What if we wanted to look at each conference room from 01/01/2016 to 12/31/2016 from 0800 to 1700? We want to see usage during a typical 8 hour work day. Thank you so much!!
ReplyDeleteHi,
DeleteGlad to hear the script has been useful! :)
For the date range, all you need to do is change the $From and $To parameters when you call the script. The issue here is to exclude meetings outside of business hours. The script processes each meeting one by one inside the "ForEach ($meeting in $calItems)" loop. Inside this loop, $meeting.Start will tell you the start time of the meeting, so you can use this value to exclude meetings if the start time is before 8:00! The same thing applies for when the meeting finishes, depending on how you want to count/exclude meetings that terminate after 17:00.
Hope this helps.
Best regards,
Nuno
Extremely helpful!!!!!!!
ReplyDeleteThank you! :)
Delete