Solved

Office 365 - Meeting Room Booking

Posted on 2014-01-15
4
2,317 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 39

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 39

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 39

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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now