This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 76%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Is Dynamic Distribution Group Based on Manager and Reportees possible?
I am trying to create dynamic distribution list using below command where it should populate all the reportees under a manager.
New-DynamicDistributionGroup -Name 'DDLName' -RecipientFilter {(Recipienttype -eq 'UserMailbox') -and (Manager -eq 'CN=XXX,OU=XXX,OU=US,OU=XXX,OU=XXX,DC=XXX,DC=XXX')}
The above command did work and created a DDL, however did not populate the members. Hence is the "Manager -eq" operator valid? Is there any other way to achieve this without using exchange custom attribute?
Current Environment :
On-prem AD
AAD connect
Exchange Online
It's possible, and you are using the correct filter syntax. If you are checking the members via the Get-DynamicDistributionGroupMember cmdlet, keep in mind that it can take up to 24h to populate all the members. You can "preview" the results via the Get-Recipient cmdlet and using the same filter.
Used the below command as suggested by Microsoft to view the members, still does not show up. It has been more than 2 weeks since the DDL was provisioned.
$FTE = Get-DynamicDistributionGroup -Identity "Full Time Employees"
Get-Recipient -RecipientPreviewFilter ($FTE.RecipientFilter)
Is there any official Microsoft article about this operator Manager -eq ? Thank you.
Even tried below command which also worked but did not populate the members:
New-DynamicDistributionGroup -Name 'DDLName' -RecipientFilter {(Recipienttype -eq 'UserMailbox') -and (Manager -eq 'Display name of manager')}
You cannot use a DisplayName value, only the DN. Here's a working example, as you can see it matches your syntax:
Get-Recipient -RecipientPreviewFilter (Get-DynamicDistributionGroup managerDDG).RecipientFilter
Name RecipientType
---- -------------
vasil UserMailbox
shared UserMailbox
gosho UserMailbox
(Get-DynamicDistributionGroup managerDDG).RecipientFilter
((((Manager -eq 'CN=HuKu,OU=michev.onmicrosoft.com,OU=Microsoft Exchange Hosted Organizations,DC=EURPR03A001,DC=prod,DC=outlook,DC=com') -and (RecipientType -eq 'UserMailbox')))
If you are still not seeing proper results, make sure the users themselves have a proper value for Manager stamped.
Still does not show the members.
Can you please elaborate "make sure the users themselves have a proper value for Manager stamped"
I have checked that they have manager set on AD > user properties > organization tab > manager correctly, if that is what you are referring to. Any other suggestions? Thank you
Still does not show the members.
Can you please elaborate "make sure the users themselves have a proper value for Manager stamped"
I have checked that they have manager set on AD > user properties > organization tab > manager correctly, if that is what you are referring to. Any other suggestions? Thank you
Finally Solved: the canonical name on the On-prem AD is different from Canonical name on the get-mailbox | fl . DDL will only take the Canonical name of the Azure AD which will be in below format:
CN=userName,OU=Contoso.onmicrosoft.com,OU=Microsoft Exchange Hosted Organizations,DC=NAMPR1008,DC=PROD,DC=OUTLOOK,DC=COM
CN=XXX,OU=XXX,OU=US,OU=XXX,OU=XXX,DC=XXX,DC=XXX - Does not work .
Yes, we could get the response from the GitHub.
Due to the forum policy, the question author cannot accept their own answer. They can only accept answers by others. I will merger this one into michev‘s answer.
I would suggest you accept the michev‘s suggestion as an answer which could be beneficial to other community members reading this thread.
Here is test in my tenant:
When use "-ne $null", I could find this mailbox. But cannot find this mailbox when use "Manager -eq "Admin_User"".
I helped you open an issue in the GitHub, we could wait to response from it: Issue about using "Manager" for -RecipientFilter
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.