Solved

Exchange 2010 List Room Mailboxes and Delegates Powershell Command

Posted on 2013-12-31
6
4,584 Views
Last Modified: 2013-12-31
I need a powershell script that will list all the room mailboxes, their delegates, and if that room mailbox is set to forward meeting requests to delegates.
0
Comment
Question by:fireguy1125
[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
  • 3
6 Comments
 
LVL 53

Expert Comment

by:Will Szymkowski
ID: 39748624
You cannot get delegate information from Powershell. You can however accomplish most of what you are looking for. See below...

GrantSendOnBehalfTo will give you a good indication of your delegates as delegates have this permissions when it is granted.

get-mailbox | ? {$_.ResourceType -eq "Room"} | select name, resourceType, GrantSendOnBehalfTo, Forwardingsmptaddress, forwardingaddress

Open in new window


Will.
0
 
LVL 1

Author Comment

by:fireguy1125
ID: 39748641
Thanks, how can I get the results in csv format, and the GrandSendOnBehalfTo shown as just the Display name and not the full AD path - I essentially want to get this into excel to distribute.
0
 
LVL 53

Expert Comment

by:Will Szymkowski
ID: 39748657
Use the below command...

get-mailbox | ? {$_.ResourceType -eq "Room"} | select name, resourceType, GrantSendOnBehalfTo, Forwardingsmptaddress, forwardingaddress | export-csv "c:\resourcemailboxes.csv"

Open in new window


Will.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:fireguy1125
ID: 39748687
Thanks, weird, but in the CSV its populating the GrantSendOnBehalfTo as the following in each item:

Microsoft.Exchange.Data.Directory.ADMultiValuedProperty`1[Microsoft.Exchange.Data.Directory.ADObjectId]

Your original showed valid data in the Powershell window - any ideas why that's the case?
0
 
LVL 53

Accepted Solution

by:
Will Szymkowski earned 500 total points
ID: 39748693
Its due to the property value.

try using | out-file "c:\resourcemailbox.csv"

instead of | export-csv "c:\resourcemailbox.csv"

this should work for you.
0
 
LVL 1

Author Closing Comment

by:fireguy1125
ID: 39748699
Thanks! Happy new year!
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

In previous parts of this Nano Server deployment series, we learned how to create, deploy and configure Nano Server as a Hyper-V host. In this part, we will look for a clustering option. We will create a Hyper-V cluster of 3 Nano Server host nodes w…
Unified and professional email signatures help maintain a consistent company brand image to the outside world. This article shows how to create an email signature in Exchange Server 2010 using a transport rule and how to overcome native limitations …
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

691 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