?
Solved

Exchange 2010 List Room Mailboxes and Delegates Powershell Command

Posted on 2013-12-31
6
Medium Priority
?
4,803 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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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 2000 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed. Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

752 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