Office 365 - Meeting Room Booking

Hi All,

I have been a member for a few months now and found the site very useful in answering a lot of my questions however I have an issue that I can not find any answers to.

We have a hybrid enviroment for office 365 for email only - and recently made changes to our meeting room booking system. The meeting rooms are now set up correctly but previously had been setup wrong ( not by me ) they were configured to not accept requests automatically so all of the meeting requests are sitting in the calendars as tentative.

We could go through each calendar and accept each meeting manually but due to the amount of entries I was hoping there may be a way of doing this with powershell or some form of script.

Any advise would be greatly appreciated, even if it is just to say it is not possible.

Thanks in  advance
mthomas1976Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vasil Michev (MVP)Commented:
There is no pre-defined PowerShell cmdlet for this, you will have to use EWS:

http://msdn.microsoft.com/en-us/library/office/dd633648(v=exchg.80).aspx

I'm not really a programmer so I might be describing it in the wrong terms, but you will have to connect to the mailbox using impersonation, probably use a search folder to get all request (or maybe not, a room mailbox rarely has any normal messages in it) and accept each of them.

Another approach that also might work:

http://serverfault.com/questions/305000/powershell-script-to-find-meeting-requests-in-exchange-mailbox-and-accept-them

You should be able to connect to the room mailbox in Outlook, just give yourself full permissions and configure the profile in Outlook, when asked for password for the room mailbox, provide your username/password instead
0
mthomas1976Author Commented:
Thanks for the clarification, I was hoping a simple powershell script would work :(

We could go down the EWS route but I doubt they will invest in the time to develop this fix when it will probably only be used once to correct the error.  They will probably just get the PA's to go through each meeting room manually.  

Thanks for the quiick response though mush appreciated.

Mike
0
Vasil Michev (MVP)Commented:
It sounds like a fun task and I definitely need to improve my EWS knowledge, so I will probably give it a try when I find some free time. Don't count on it though :)
0
Vasil Michev (MVP)Commented:
OK so here's the deal: you can only RESPOND to items that are meeting requests, i.e. you have not responded yet to them (Microsoft.Exchange.WebServices.Data.MeetingRequest)

Once you do an action (accept/deny/tentative/etc), the original meeting request is (usually) removed. You might (or might not) have the corresponding RESPONSE in the mailbox, but you cannot do any of these actions on it (different class Microsoft.Exchange.WebServices.Data.MeetingResponse)

Now, they way I understand your situation is, that all the requests are just sitting in the mailboxes WAITING for an action. If this is indeed the case, I should be able to make it work. If instead, you mean that an actual TENTATIVE reply has been sent, probably not gonna work.

Which one is it? :)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Office 365

From novice to tech pro — start learning today.