Solved

Exchange 2010 Management Shell

Posted on 2015-01-10
1
72 Views
Last Modified: 2015-01-12
This is the senerio. I have users with full manage access to shared mailboxes, but we have been involved in a mailbox migration from 1 org to another and as a result the mailbox permissions have been broken. I have an
excel .csv file with all the mailboxes that each user has permissions to. This is in the hundreds of mailboxes and users have access to multiple mailboxes. In the Excel csv file I have the name of the mailboxes and the users that has access to them. Is there a way that a script can be run in EMS against the .csv so that it will assign those users back to the mailbox. This is the script I generally run when there is 1 .csv with multiple users accessing the same mailbox I generally export all the users in a csv into a variable and them manually specify the name of the mailbox identity:

$userList = Import-Csv .\excel\name.csv
foreach ($user In $userList) {
Add-MailboxPermission -Identity “mailbox name” -User $user.Name -AccessRights FullAccess–InheritanceType All
}

So now, I have 1 .csv but in this csv there are multiple users and multiple mailboxes, and I would like to know how to run a similar script or cmdlet against the info in the csv so that those users can be reassigned the mailboxes they are next to in the csv file. Any assistance will be greatly appreciated.

example.xlsx
0
Comment
Question by:timgreen7077
1 Comment
 
LVL 68

Accepted Solution

by:
Qlemo earned 500 total points
ID: 40542837
Let's assume the mailbox name column in the CSV  is Mailbox, as the username is Name. Then all you have to change in your script is to replace "mailbox name" with $user.Mailbox.
According to the attached CSV, it is different:
foreach ($user In Import-Csv .\excel\name.csv) {
  Add-MailboxPermission -Identity $user.Identity -User $user.User -AccessRights FullAccess–InheritanceType All
}

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
A procedure for exporting installed hotfix details of remote computers using powershell
how to add IIS SMTP to handle application/Scanner relays into office 365.
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

911 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

17 Experts available now in Live!

Get 1:1 Help Now