none
Report on conference room usage? RRS feed

  • Question

  • Exchange 2007 SP3

    I've been asked to create a report on conference room usage at our company.  They want to know which rooms are booked and for how long, as well as overall availability of conference rooms.  The idea is that they want to shut down an area of the building but they're concerned that it will leave the company with an inadequate number of conference rooms.

    Maybe someone knows of a powershell script or third party app that can do that?

    Unfortunately we don't own MOM, so that option is out.  :(

    Thanks in advance.

    Friday, March 16, 2012 1:12 PM

Answers

All replies

  • See if this works.

    FreeBusy In/Out Board for Exchange 2007 using EWS and Powershell

    http://gsexdev.blogspot.com/2008/12/freebusy-inout-board-for-exchange-2007.html


    James Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com

    Friday, March 16, 2012 2:26 PM
  • Hmm.  It looks interesting, but i'm not sure it's going to do what i want.  What they're really looking for is how many hours out of the business day is a particular room booked for, and then present that as a percentage of available vs booked.  A chart would be nice, but numbers are fine too.  This sounds like some kind of third party app me thinks.  I definitely don't have the powershell or programmings skill sets to build something like that myself.
    Friday, March 16, 2012 2:58 PM
  • Yeah I haven't seen any pre-canned historical usage reporting scripts for rooms in the past. You will likely probabaly have to resort to third party. Might look into below and test out the trial if you haven't seen it already.

    http://vboffice.net/product.html?lang=en&id=2006073&cmd=detail


    James Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com

    Friday, March 16, 2012 3:16 PM
  • Where is the conference room data currently stored?  Do you have resource mailboxes for each conference room?


    Jim McBee - Blog - http://mostlyexchange.blogspot.com

    Sunday, March 18, 2012 4:25 AM
  • It's stored in the mailbox.  All of our conference rooms are resource mailboxes.
    Monday, March 19, 2012 1:07 PM
  • Hi blinkjesus,

    Per your issue, there would be no deirect method to achieve your target,  it need to do some development, I would suggest that you could post it in below forum:
    http://social.technet.microsoft.com/Forums/en-US/exchangesvrdevelopment/threads 
    Then, you will get more help from there.

    Regards!

    Gavin

    TechNet Community Support

    • Marked as answer by Gavin-Zhang Wednesday, April 4, 2012 6:02 AM
    Tuesday, March 20, 2012 9:34 AM
  • Thanks Gavin.
    Tuesday, March 20, 2012 12:47 PM
  • HI blink

    if you share your caledar through mail, you can see the free/busy of rooms and can see how long they are going to use the particular room. we can export that room utilization report into excel also.

    Hi Gavin,

    am also working on the same task, is it possible to pull the report of room utilization as mentioned below?

    This is what the report should show the items below.  However, we should be able to use the same process to report for any room.

    1. Room usage for a week for each specific room (usage is relative to how many hours the room is available for the day)
    2. Room usage for a month for each specific room (usage is relative to how many hours the room is available for the week)
    3. Number of bookings per user
    4. Number of bookings canceled
    5. Number of bookings rescheduled
    Tuesday, June 26, 2012 9:16 PM
  • Thanks!
    Wednesday, June 27, 2012 2:56 PM
  • Did you get anywhere with this?  I need the same exact thing.

    Tuesday, May 20, 2014 12:59 PM
  • Maybe someone knows of a powershell script or third party app that can do that?

    Our product can do that. We recently developed a new report that can 'scan' Room/User mailboxes, extract the meetings they contain, display them at different detail levels (Mailbox, Summary, Detail of attendees). It is also able to calculate occupancy rates on meeting rooms, and it even takes business hours into account.

    Example: If "Meeting Room A" was booked from 8 AM to 6 PM from Monday to Friday (10 hours a day, 5 days) and the office is open from 6 AM to 7 PM from Monday to Friday (13 hours a day, 5 days), the report will calculate that its occupancy rate was 76.9% during that week - and not 29.8% of 7 days of 24 hours.

    We named that report Calendar Item Search. You can download PROMODAG Reports on our website and try it for free for 45 days: http://www.promodag.com/downloads/

    Friday, May 20, 2016 10:05 AM
  • Here is an article that I think might help you out. http://letsexchange.blogspot.com/2017/05/exchange-meeting-room-statistics.html

    I have been using the old version of this script and just found this one. I'm testing it now. I have one conference room that won't dump the information to the report on the old one so I'm hoping this will work. I had three others that weren't working either but I found that they needed an x500 address. I checked the RPC client logs and found the error for them and used that to create the x500 address. But this last conference room is not throwing the error. So I've been trying to find something else to fix and ran across this new script.

    Hope this helps!

    Tuesday, May 23, 2017 12:40 PM