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-Object -expandP
Read more

Laptop Battery Replacement

Image
     I recently replaced the battery in one of my laptops. For the past few months I have been living with a battery that has drained quickly, even after charging over night.        The process was simple and did not require any special tools. Best of all it only took a few minutes to complete.        The Laptop in question was a Toshiba Satellite L55t-A5186. I picked this laptop up second hand from a individual who mainly used it for work. It was well cared for, but it is older.      Anyways, to replace this battery I had to remove a number of screws (12) from the bottom of the laptop. One of the screws held the CD-ROM drive in place. The CD-ROM drive must be fully removed in order to be able to pull the bottom off of the laptop. The CD-ROM drive is located on the right side of the laptop (if looking at the bottom of the Laptop), and just slides out after removing one of the 12 screws on the bottom.     Another part that needs to be removed is the RAM compartment cover. I'm not su
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 Exchange Server, sets up a mailbox and links i
Read more