Solved

Office 365 - Meeting Room Booking

Posted on 2014-01-15
4
2,393 Views
Last Modified: 2014-01-20
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
0
Comment
Question by:mthomas1976
  • 3
4 Comments
 
LVL 40

Expert Comment

by:Vasil Michev (MVP)
ID: 39782995
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
 

Author Comment

by:mthomas1976
ID: 39784854
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
 
LVL 40

Expert Comment

by:Vasil Michev (MVP)
ID: 39784931
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
 
LVL 40

Accepted Solution

by:
Vasil Michev (MVP) earned 500 total points
ID: 39785653
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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
This Experts Exchange lesson shows how to use VBA to loop through rows in Excel.  In order to sort, filter, and use database features, there needs to be a value in each column for every row. When data arrives with values missing, code to copy values…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question