Forum Discussion
Users not part of office distribution lists PowerShell
I'm looking to find office365 users whose primary SMTP is our domain.com that are not part of certain office365 distribution lists we have. For example Dist1, Dist2, Dist3, Dist4 and export the resul...
Sam240 I created this one in my test tenant:
Script:
Connect-ExchangeOnline
$total = @()
$users = Get-Mailbox | Where-Object PrimarySmtpAddress -Match 'M365x537152.OnMicrosoft.com' | where-object PrimarySmtpAddress -NotMatch 'DiscoverySearchMailbox' | Sort-Object UserPrincipalName
$distributiongroups = "Executives", "Sales Team", "Tailspin Toys"
foreach ($distributiongroup in $distributiongroups) {
$distributiongroupmembers = Get-DistributionGroupMember -Identity $distributiongroup
foreach ($user in $users) {
if (-not ($distributiongroupmembers | Select-String $user.name)) {
$output = [pscustomobject]@{
"DistributiongroupName" = $distributiongroup
"UserName which is not a Member" = $user.UserPrincipalName
}
$total += $output
}
}
}
$total | Export-Csv -Path c:\temp\distributiongroups.csv -NoTypeInformation -Delimiter ';'
CSV:
Why the two client side filters in the Get-Mailbox line? Performance wise that looks strange.
Can't we use a server side filter on Get-Mailbox for the two PrimarySmtpAddress elements?
Can't we use a server side filter on Get-Mailbox for the two PrimarySmtpAddress elements?
You can use whatever filter you want 😉 I added the discoverymailbox because it was also evaluated, you can leave that out if you want.. Performance wise there was no impact in my test environment, very few users, but in larger environments it could take somewhat longer. But is this something you run once in a while or daily?
Shorter version:
Get-Mailbox | Where-Object {$_.PrimarySmtpAddress -Match 'M365x537152.OnMicrosoft.com' -and $_.PrimarySmtpAddress -NotMatch 'DiscoverySearchMailbox'} | Sort-Object UserPrincipalNameCan't this all be done server side.
Get-Mailbox -Filter {$_.PrimarySmtpAddress -Match 'M365x537152.OnMicrosoft.com' -and $_.PrimarySmtpAddress -NotMatch 'DiscoverySearchMailbox'} | Sort-Object UserPrincipalName- Not sure what you mean with server side? You connect Exchange Online and run the commands directory on that...
