asked on 12/31/2013

Exchange 2010 List Room Mailboxes and Delegates Powershell Command

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.

Exchange Powershell

Last Comment

fireguy1125

12/31/2013

Will Szymkowski

12/31/2013

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.

fireguy1125

12/31/2013

ASKER

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.

Will Szymkowski

12/31/2013

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.

fireguy1125

12/31/2013

ASKER

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?

ASKER CERTIFIED SOLUTION

Will Szymkowski

12/31/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

fireguy1125

12/31/2013

ASKER

Thanks! Happy new year!