Forum Discussion
Solved
Get a report showing specific shared mailboxes and Display Names of their members on one line.
Dear Community, I have been asked to generate an excel report showing all our shared mailboxes starting with "jobs-". For each shared mailbox we want to see the members' Display Names (not the emai...
- Sorry, that's what happens when I write code directly in the browser 😄
For the sorting bit, this should do:
$membersString = ($memberNames | sort -Unique) -join ", "
Move the code to the parent loop:
$jobs = Get-EXOMailbox -RecipientTypeDetails SharedMailbox -ResultSize Unlimited -Filter { DisplayName -like 'jobs-*' }
$JobsReport = @()
foreach ($job in $jobs) {
$Members = Get-MailboxPermission $job.identity | Where-Object { ($_.User -like '*@*') | Sort-Object User
foreach ($Member in $Members) {
$DisplayName = ((Get-User $Member.User).DisplayName) -join ', '
}
$JobsReport += [PSCustomObject]@{
SharedMailbox = $job.Alias
MemberDN = $DisplayName
}
} Thank you VasilMichev for your reply. I tried the code, but it doesn't work. For each shared mailbox I get only one name and not the full list of members. Is there something else I am missing?
Ah, I forgot to append the value. Try with:
$jobs = Get-EXOMailbox -RecipientTypeDetails SharedMailbox -ResultSize Unlimited -Filter { DisplayName -like 'jobs-*' } $JobsReport = @() foreach ($job in $jobs) { $Members = Get-MailboxPermission $job.identity | Where-Object { ($_.User -like '*@*') | Sort-Object User foreach ($Member in $Members) { $DisplayName += ((Get-User $Member.User).DisplayName) } $JobsReport += [PSCustomObject]@{ SharedMailbox = $job.Alias MemberDN = $DisplayName -join "," } }VasilMichev, thank you for your time, unfortunately the script is not working...
Now I get the same names repeated N times for each mailbox without delimiter and not sorted.
