Solved

Exchange 2010 List Room Mailboxes and Delegates Powershell Command

Posted on 2013-12-31
6
3,813 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
  • 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
Do email signature updates give you a headache?

Do you feel like all of your time is spent managing email signatures? Too busy to visit every user’s desk to make updates? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today!

 
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
In this video we show how to create a Shared Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Sha…
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…

744 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

9 Experts available now in Live!

Get 1:1 Help Now