powershell - 将共享邮箱权限导出到 .csv

Question

我需要学习如何制作一个脚本，让所有有权访问我们业务中共享邮箱的用户。

例如：

共享邮箱：[e-mail]

我想像这样导出为 .csv：

| Username | Access | Mailbox |
| john.peterson | Full Access | [e-mail] |
| anne.wall | Full Access | [e-mail] |
| jason.doe | Full Access | [e-mail] |
| tim.carlson |Full Access | [e-mail] |

标签： powershelloffice365export-to-csv

Answer 1

首先安装Exchange Online PowerShell 模块 v2：

Install-Module -Name ExchangeOnlineManagement

那么下面的代码应该可以完成这项工作：

# Connect to Exchange Online
Connect-ExchangeOnline

# Retrieve mailbox permissions
$sharedMailbox = '[e-mail]'
$permissions = Get-MailboxPermission -Identity $sharedMailbox

# Format the permissions to have the column names you asked for
$formattedPermissions = $permissions `
| Select-Object -Property @{Name='Username';Expression={$_.User}},@{Name='Access';Expression={$_.AccessRights}},@{Name='Mailbox';Expression={$sharedMailbox}}

# Export to CSV, delimiter can be adjusted
$formattedPermissions | Export-Csv -Path permissions.csv -Delimiter ',' -Encoding UTF8 -NoTypeInformation