Forum Discussion
Listing shared mailboxes and members - Powershell
Here is the powershell to get this
Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize:Unlimited | Get-MailboxPermission | select identity,user,accessrights | where { ($_.User -like '*@*') }
Paris Wells Thanks Buddy, its working good!! \you help me a lot!
Paris Wells Just wanted to say thank you! This worked perfectly. Piped it to Export-CSV, turned that into an XLSX and off to management it goes for review.
Thanks!Thanks for the script. Can i get a list of send as permissions too along with accessrights?
Neeraj Ail
I hope this will help you.
https://o365reports.com/2020/01/03/shared-mailbox-permission-report-to-csv/
This script exports shared mailbox permissions like full access, send as and send on behalf to CSV file.- You can see sendas permissions using the Get-RecipientPermission cmdlet.
thanks it worked.
Get-RecipientPermission -Identity "mailbox" -AccessRights sendas | where {($_.trustee -like '*@*') }
Paris Wells wrote:
Here is the powershell to get this
Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize:Unlimited | Get-MailboxPermission | select identity,user,accessrights | where { ($_.User -like '*@*') }
Can you add a way to export the result to an Excel file. Would really appreciate it. Thanks!
Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize:Unlimited | Get-MailboxPermission | select identity,user,accessrights | where { ($_.User -like '*@*') } | Export-csv -path D:\Gowher.CSV
What I do is sending the results to a txt file, just adding :
>myfilename.txt
at the end of the sentence.
- You can pipe the result to a csv file Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize:Unlimited | Get-MailboxPermission | select identity,user,accessrights | where { ($_.User -like '*@*') } | Export-Csv -path -NoTypeInformation more info bout export-csv can be found here: https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/export-csv?view=powershell-6
