What are the requirements for using this script?<\/h3>\n
For this PowerShell script to work properly, there are basically only 2 technical requirements:<\/p>\n
- \n
- The script should be executed with PowerShell 7.<\/li>\n
- Exchange online PowerShell module must be installed.<\/li>\n<\/ul>\n
Other soft requirements are of course the necessary permissions to edit the actions of access rights to Exchange online mailboxes and a CSV file, which should be prepared before executing this script.<\/p>\n
\u00a0<\/p>\n
What must this CSV file look like?<\/h3>\n
The CSV file requires 4 pieces of information, which should be created as follows:<\/p>\n
\n\n
\n \nHeader<\/th>\n Description<\/th>\n<\/tr>\n<\/thead>\n \n MailboxIdentity<\/code><\/td>\nThe email address or alias of the mailbox to modify.<\/td>\n<\/tr>\n \n UserIdentity<\/code><\/td>\nThe email address or alias of the user to grant permissions to.<\/td>\n<\/tr>\n \n SendAs<\/code><\/td>\nSet to\u00a0 TRUE<\/code>\u00a0to grant \u201cSend As\u201d permission,\u00a0FALSE<\/code>\u00a0otherwise.<\/td>\n<\/tr>\n\n FullAccess<\/code><\/td>\nSet to\u00a0 TRUE<\/code>\u00a0to grant \u201cFull Access\u201d permission,\u00a0FALSE<\/code>\u00a0otherwise.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\nThis means that the CSV should look like this:<\/p>\n
MailboxIdentity,UserIdentity,SendAs,FullAccess\r\nshared.mailbox@company.com,john.doe@company.com,TRUE,TRUE\r\nshared.mailbox@company.com,jane.smith@company.com,TRUE,FALSE\r\nshared.mailbox@company.com,admin@company.com,FALSE,TRUE\r\nfinance@company.com,john.doe@company.com,TRUE,TRUE\r\nfinance@company.com,finance.manager@company.com,TRUE,TRUE<\/code><\/pre>\n\u00a0<\/p>\n
IMPORTANT:<\/strong><\/span> If there are other permissions set for the mailbox defined under \u201cMailboxIdentity\u201d that are not included in this CSV, these permissions will be removed<\/strong> when the script is executed.
\nWhy? I have also created this script with the intention of cleaning up permissions.<\/p>\n\u00a0<\/p>\n
How does the script behave when it is executed?<\/h3>\n
\n\n
\n ![\"\"](\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2025\/06\/1Screenshot-2025-06-05-130532-1.png\")
<\/td>\n\u00a0<\/p>\n When the script is started and after the license conditions for this script have been accepted, the following dialog box appears, which explains again exactly what this PowerShell script does.<\/p>\n
\u00a0<\/td>\n<\/tr>\n
\n ![\"\"](\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2025\/06\/2Screenshot-2025-06-05-130639.png\")
<\/td>\n\u00a0<\/p>\n Now another Windows window opens, here we can now select the prepared CSV file.<\/p>\n
\u00a0<\/td>\n<\/tr>\n
\n ![\"\"](\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2025\/06\/3Screenshot-2025-06-05-130737.png\")
<\/td>\n\u00a0<\/p>\n The next step is to set up the connection to Exchange online.<\/p>\n
\u00a0<\/td>\n<\/tr>\n
\n ![\"\"](\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2025\/06\/4Screenshot-2025-06-05-130838.png\")
<\/td>\n\u00a0<\/p>\n If \u201cYes\u201d was clicked in the previous pop-up window, we must now authenticate ourselves with our EntraID data to the Microsoft Teanant.<\/p>\n
\u00a0<\/td>\n<\/tr>\n
\n ![\"\"](\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2025\/06\/5Screenshot-2025-06-05-130907.png\")
<\/td>\n\u00a0<\/p>\n If we have successfully logged on to Exchange online, the summary from the CSV file will be displayed again. Please check this and if everything is OK, click on \u201cYes\u201d to continue.<\/p>\n
\u00a0<\/td>\n<\/tr>\n
\n ![\"\"](\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2025\/06\/6Screenshot-2025-06-05-130942-1024x756.png\")
<\/td>\n\u00a0<\/p>\n The tasks from the CSV are now processed as specified. Each step is visible in the PowerShell console.<\/p>\n
\u00a0<\/p>\n
When all tasks have been completed, another pop-up appears asking whether an HTML report should now be created.<\/p>\n
\u00a0<\/td>\n<\/tr>\n
\n ![\"\"](\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2025\/06\/7Screenshot-2025-06-05-131014.png\")
<\/td>\n\u00a0<\/p>\n Last but not least, there is an overview of what was actually done when this script was executed and where the HTML report is stored.<\/p>\n
\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Reporting<\/h3>\n
After the script has run, an HTML file is created as a report. This HTML report is saved in the same place where we previously selected the CSV file.
\nBelow is an example of how this HTML report can look.<\/p>\n![\"\"](\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2025\/06\/Screenshot-2025-06-05-130055-984x1024.png\")
<\/p>\nGet the Script<\/h3>\n
As always, although I have tested and used the script several times, I cannot and will not accept any liability for the use of this script.
\nReaders who download the script are free to customize it according to their needs. Commercial use is allowed, but monetarization requires my explicit permission.<\/p>\n