Export Public folder permission

Question

I am trying to export public folder permission with the user's email address. Using the below script I can get the details of AccessRights and User name. Can anyone help, how to add the user’s email address to the script?

Get-PublicFolder -Recurse -resultsize unlimited | Get-PublicFolderClientPermission | Select-Object Identity,@{Expression={$.User};Label="User";},@{Expression={$.AccessRights};Label="AccessRights";} | Export-Csv C:\PublicFolderClientPermission.csv

Answer 1

@Austin Sundar

I modified the command again, and it works on my Exchange 2010 SP3 ru30. Please try it on your Exchange server:

Get-PublicFolder -Recurse -resultsize unlimited | Get-PublicFolderClientPermission | Select-Object Identity,@{Expression={$_.User};Label="User"},@{Name='AccessRights';Expression={[string]::join(', ', $_.AccessRights)}},@{label="PrimarySmtpAddress";expression={(Get-Mailbox $_.User.tostring()).PrimarySmtpAddress}}|export-csv C:\location\pubpermission.csv -NoTypeInformation  

This my output:

Additionally, since Exchange 2010 is end of support, we suggest to migrate to Office 365 or Exchange 2016 for better services. For your reference: Exchange 2010 end of support roadmap.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You can try something like this:

Get-PublicFolder -Recurse -resultsize unlimited | Get-PublicFolderClientPermission | Select-Object Identity,@{e={$_.User};Label="User"},@{e={$_.User.RecipientPrincipal.PrimarySmtpAddress};Label="Email"},@{Expression={$.AccessRights};Label="AccessRights";} | Export-Csv C:\PublicFolderClientPermission.csv

I've tested it against ExO only, but something similar should work for on-prem Exchange too.

Answer 3

@Austin Sundar

I made some modification on your command, and you can use the following command to get needed information:

Get-PublicFolder -Recurse -resultsize unlimited | Get-PublicFolderClientPermission | Select-Object Identity,@{Expression={$_.User};Label="User"},@{Name='AccessRights';Expression={[string]::join(', ', $_.AccessRights)}},@{label="PrimarySmtpAddress";expression={(Get-Mailbox $_.User.displayname).PrimarySmtpAddress}}|export-csv C:\location\pubpermission.csv -NoTypeInformation  

Here is my test result:

This is my .csv file:

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

What's the detailed version of your Exchange servers?
What's the output of the command without exporting?

Get-PublicFolder -Recurse -resultsize unlimited | Get-PublicFolderClientPermission | Select-Object Identity,@{Expression={$_.User};Label="User"},@{Name='AccessRights';Expression={[string]::join(', ', $_.AccessRights)}},@{label="PrimarySmtpAddress";expression={(Get-Mailbox $_.User.displayname).PrimarySmtpAddress}}  

This is my output. You can post your result here, and don't forget to cover personal information.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.