Forum Discussion

MGlomski's avatar
MGlomski
Copper Contributor
Feb 22, 2024

Dynamic Distribution Group User Exclusion Recipient Filter

I have a dynamic distribution group that uses Office locations for its recipient filter.  It is able to pick up all of the users needed, however, there are a few service accounts I want to exclude f...
Distribution Group
email
exchange
office 365
VasilMichev's avatar
VasilMichev
MVP
Feb 23, 2024
Put some additional () around the Office conditions, they should all be in the same group. You can also try replacing the UserPrincipalName with something like Name or Alias, as there is some fishy behavior with it, especially when combined with -like.

How are you checking the membership? If using the Get-DynamicDistributionGroupMember cmdlet, remember it only updates once every 24h or so.
  • MGlomski's avatar
    MGlomski
    Copper Contributor
    Feb 23, 2024

    VasilMichev 

    I have been using the (get-dynamicdistributiongroupmember -identity $identity | Select-object DisplayName,PrimarySmtpAddress) to get recipients. 

    I've also been using: 

    $filter = $TheRecipientFilterSyntax
    Get-Recipient -filter $filter | Select-object DisplayName,PrimarySmtpAddress

    I'm testing with the following now: 
    "(((Office -eq 'Spokane, WA')) -or ((Office -eq 'Sandpoint, ID')) -and (RecipientType -eq 'UserMailbox') -and (RecipientTypeDetails -eq 'UserMailbox') -and (-not(Name -like '<service-account's-name>')) -and (-not(Name -like '<service-account's-name>*')))"

    I've got a wild-card on the last one because there's a handful of service accounts with ascending numbers that match that ANR. 

    Thanks for the tip! Hopefully this gets the results I'm looking for. 
    Will check back in next week.

    • MGlomski's avatar
      MGlomski
      Copper Contributor
      Mar 06, 2024
      Unfortunately the exclusion did not take successfully and the service accounts are still being shown as recipients.

Resources