Users not part of office distribution lists PowerShell

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: