we are having around 90 rooms mailbox in exchange 2010, Now i want to extract the caledar report of rooms in exchage server 2010 using powershell. the report should contain the following details.

a. Room usage for a week for each specific room (usage is relative to how many hours the room is available for the day) b. Room usage for a month for each specific room (usage is relative to how many hours the room is available for the week) c. Number of bookings per user d. Number of bookings canceled e. Number of bookings rescheduled

is there any possibility to get the report with above mentioned points into excel using powershell in exchage server?

if i do exprot from outlook for room calendar, i can get the report for only one room. and is it possible to get the report of all room calendar?

Pls guide me. this task is pending since from the long time.

Thanks in advance

Sankar M



Software/Hardware used: