Getting the email addresses for shared mailboxes

Question

I am able to get the shared mailbox and permissions using the PowerShell script below. How would I add the shared mailbox email address and alias to the script also. Thank you for your help.

Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize:Unlimited
     |Get-MailboxPermission |Select-Object Identity,User,{$_.AccessRights}
     | Where-Object {($_.user -like 'domain*')} |Export-Csv e:\sharedMBX.csv -NoTypeInformation

Answer 1

Hi @ mara2021 ,

The following script can achieve your requirements, please modify "domain" and run it:

# Get information about all shared mailboxes
$SharedMailboxes = Get-Mailbox -Filter {RecipientTypeDetails -eq "SharedMailbox"}|Select-Object Identity,PrimarySmtpAddress,Alias

# Loop through each shared mailbox
$Data = foreach ($SharedMailbox in $SharedMailboxes) {

   
    $Users = Get-MailboxPermission -Identity $SharedMailbox | Select-Object  User,AccessRights | Where-Object {($_.user -like    '*domain*')}
    foreach($user in $Users){
   

    [PSCustomObject]@{
            "Identity" = $SharedMailbox.Identity   
            "EmailAddress" = $SharedMailbox.PrimarySmtpAddress   
            "Alias" = $SharedMailbox.Alias   
            "User" = $user.user
            "Permission" = $user.AccessRights
        }
    }
    
}

# Export data to CSV file
$Data | Export-Csv -Path "c:\SharedMailboxes.csv" -NoTypeInformation

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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 use something like this:

Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize:Unlimited |
    ForEach-Object{
        if ($_.user -like 'domain*'){
            $props = [ordered]@{
                EmailAddress = $_.emailaddress
                Alias = $_.Alias
                Identity = ""
                User = ""
                AccessRights = ""
            }
            $m =  $_ | Get-MailboxPermission | Select-Object Identity,User,{$_.AccessRights}
            $props.Identity = $m.Identity
            $props.User = $m.User
            $props.AccssRights = $m | Select-Object -Expand AccessRights
            [PSCustomObject]$props
        } 
    } |Export-Csv e:\sharedMBX.csv -NoTypeInformation

I don't have access to an Exchange organization so I'm not sure that the property names are correct (I used the ones in your code).

I do know that you are not going to be able to export the AccessRights to a CSV without further processing them, because there's no way to add an array to a CSV. I'm also pretty sure that an individual access right isn't just a simple name. It might be, for example, an "allow" or "deny" permission.