Report on conference room usage?
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.
March 16th, 2012 9:12am
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.htmlJames Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
March 16th, 2012 10:26am
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.
March 16th, 2012 10:58am
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=detailJames Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
March 16th, 2012 11:16am
Where is the conference room data currently stored? Do you have resource mailboxes for each conference room?
Jim McBee - Blog - http://mostlyexchange.blogspot.com
March 18th, 2012 12:25am
It's stored in the mailbox. All of our conference rooms are resource mailboxes.
Free Windows Admin Tool Kit Click here and download it now
March 19th, 2012 9:07am
Thanks Gavin.
March 20th, 2012 8:47am
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.
Room usage for a week for each specific room (usage is relative to how many hours the room is available for the day)Room usage for a month for each specific room (usage is relative to how many hours the room is available for the week)Number of bookings per userNumber of bookings canceledNumber of bookings rescheduled
Free Windows Admin Tool Kit Click here and download it now
June 26th, 2012 5:16pm
Thanks!
June 27th, 2012 10:56am