PowerShell: Update User Permissions for a Shared Mailbox or Calendar using Add-MailboxFolderPermission

 I use this simple script to update permissions for a Shared Calendar for a group of Users.  This can be used for updating permissions to other Shared Mailbox Folders also.


 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
#Connect to Exchange Online
Connect-ExchangeOnline -UserPrincipalName alex.g@COMPANY.com

#Create a list of User email addressses by seraching specific OUs and adding them to a users variable.
$users = get-aduser -filter * -SearchBase "OU=MEC_Operations,OU=MEC,OU=COMPANY Users,DC=COMPANY,DC=local" -Properties mail | Select-Object mail
$users += get-aduser -filter * -SearchBase "OU=COL_Operations,OU=COL,OU=COMPANY Users,DC=COMPANY,DC=local" -Properties mail | Select-Object mail
$users += get-aduser -filter * -SearchBase "OU=HAR_Operations,OU=HAR,OU=COMPANY Users,DC=COMPANY,DC=local" -Properties mail | Select-Object mail
$users += get-aduser -filter * -SearchBase "OU=RIC_Operations,OU=RIC,OU=COMPANY Users,DC=COMPANY,DC=local" -Properties mail | Select-Object mail
$users += get-aduser -filter * -SearchBase "OU=MEC_Terminal_Support,OU=MEC,OU=COMPANY Users,DC=COMPANY,DC=local" -Properties mail | Select-Object mail

#export this list to a CSV File to check for accuracy. 
$users | Export-Csv -Path C:\Users\alexg\Desktop\AccountingUsers.csv

#Prompts the user to continue the script after checking for accuracy
Read-Host -Prompt "Press Enter to continue"

#Imports the CSV file
$UsersCSV = Import-Csv -Path C:\Users\alexg\Desktop\AccountingUsers.csv

#Loops throught the CSV and sets mailbox permissions for that user.
foreach ($row in $UsersCSV) 
{
    add-mailboxfolderpermission OpsTimeOffCal@COMPANY.com:\calendar -user $row.mail  -accessrights Reviewer -SendNotificationToUser $true 
}

Comments

Post a Comment

Popular posts from this blog

A script to check a log file. If conditions are met the script will then delete, and copy in a file into the folder.

Image
 I wrote a quick script to automate a process I found myself doing every few months.   We have software that has a maximum number of licenses available. Unfortunately, when a user logs out, the software does not release that license.  To solve this issue we simply delete a .log and .dat file, and then paste a old copy of the .dat file back into that location.  Sounds kind of complicated, but it might make a little more sense looking at the script.  Lets take a look: The software will output a license count to a logfile that looks something like this. So in order to get the license count, we need to pull that log file into PowerShell, split it on the empty space, and then count the numbers remaining.  This was a little complicated for me to figure out but this is what I came up with. $split = Import-Csv C : \Users\alexg\Desktop\Scripts\license.log -Delimiter " " -Header Name,Amount $Count = $split | Measure-Object 'Amount' -Sum | Select-...
Read more

Bulk AD User creation Powershell Script

Image
 As a follow up, I want to post of one of my most recent scripts.  This script is used to do bulk AD user creation.   My company has been growing rapidly and it takes up a lot of my time when creating and setting up new employee accounts and mailboxes.  I recently spent some time writing a script to automate this process.  This script takes a CSV file that has been filled out by HR with the new employee's name and other information.  It imports that information into Active Directory and creates a user profile.   Our hiring managers often include in the service ticket the name of an employee who would have the same rights/permissions/and memberships as the new employee.  So to simplify things, I put in my CSV file a column that is the "User to Copy".  This tells the script to copy that user's profile/OU/memberof details and apply them to the new user.   Once created, the script then starts a remote session into our On-prem ...
Read more