onelinecommand

Access rights showed as System.Collections.ArrayList in csv. you have to use use ‘-join’ for the array.

Get-exoMailbox -ResultSize unlimited | Get-EXOMailboxPermission | Select Identity, User, Deny,@{n=’AccessRights’;e={$_.AccessRights -join “;”}}, IsInherited| Where {($_.user -ne “NT AUTHORITY\SELF”)}| Export-Csv “filpath\filename$(Get-Date -Format ‘dd_MM_yyyy HH_mm tt’).csv” -NoTypeInformation

using filter

Get-exoMailbox -ResultSize unlimited -Properties identity,RecipientTypeDetails,mailboxplan | Where-Object {($_.MailboxPlan -like “ExchangeOnlineEnterprise-*“) } | Get-EXOMailboxPermission | Select Identity, User, Deny,@{n=’AccessRights’;e={$_.AccessRights -join “;”}}, IsInherited| Where {($_.user -ne “NT AUTHORITY\SELF”)}| Export-Csv “filpath\filename$(Get-Date -Format ‘dd_MM_yyyy HH_mm tt’).csv” -NoTypeInformation