Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Office 365 - Meeting Room Booking

Posted on 2014-01-15
4
Medium Priority
?
2,548 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 43

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 43

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 43

Accepted Solution

by:
Vasil Michev (MVP) earned 2000 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

Are your AD admin tools letting you down?

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

Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
how to add IIS SMTP to handle application/Scanner relays into office 365.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

618 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