DDL with title is empty

Question

DDL with title is empty

Austin Sundar 436

Hi All,

I am trying to create a DDL for a specific location and exclude accounts with TITLE is empty/null.
I use the filter below but i still gets the accounts with the header is empty. could anyone help?

-RecipientFilter {(Office -like "location") -and ((-not(RecipientTypeDetailsvalue -eq 'RoomMailbox')) -and (-not(RecipientTypeDetailsvalue -eq 'SharedMailbox')) -and (-not(RecipientType -eq 'MailContact')) -and (-not(Title -eq '$null')))}

Joyce Shen - MSFT 16,706 Reputation points

2022-07-11T03:03:27.113+00:00

Hi @Austin Sundar

Any progress about youe issue here, have you tried the command shared by michev below?

If an Answer is helpful, please click "Accept Answer" and upvote it.

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.
Joyce Shen - MSFT 16,706 Reputation points

2022-07-14T08:17:59.613+00:00

Hi @Austin Sundar

I am writing to see how everything is going on with this thread. If you still have further concern on this, please feel free to let us know.

If an Answer is helpful, please click "Accept Answer" and upvote it.

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.

1 answer

Your answer

Joyce Shen - MSFT 16,706 Reputation points

2022-07-11T03:03:27.113+00:00

Hi @Austin Sundar

Any progress about youe issue here, have you tried the command shared by michev below?

If an Answer is helpful, please click "Accept Answer" and upvote it.

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.
Joyce Shen - MSFT 16,706 Reputation points

2022-07-14T08:17:59.613+00:00

Hi @Austin Sundar

I am writing to see how everything is going on with this thread. If you still have further concern on this, please feel free to let us know.

If an Answer is helpful, please click "Accept Answer" and upvote it.

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.

Answer 1

Vasil Michev 127K MVP Volunteer Moderator

You need to remove the quotes around $null, otherwise it will take it as a string value (i.e. it will only match users for which Title is set to the "$null" string value). Here's a working example:

Set-DynamicDistributionGroup test -RecipientFilter {(Office -like "Home") -and ((-not(RecipientTypeDetailsvalue -eq 'RoomMailbox')) -and (-not(RecipientTypeDetailsvalue -eq 'SharedMailbox')) -and (-not(RecipientType -eq 'MailContact')) -and (Title -ne $null))}

0 comments

Share via

DDL with title is empty

1 answer

Your answer