[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2586
  • Last Modified:

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
0
mthomas1976
Asked:
mthomas1976
  • 3
1 Solution
 
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now