Select the product you need help with

Error message in Exchange Management Shell in Microsoft Exchange Server 2007 when you run the "new-dynamicdistributiongroup" command: “You must provide a value expression on the right-hand side of the '-and' operator.”

Article ID: 973490 - View products that this article applies to.

SYMPTOMS

You can use Dynamic Distribution Group (DDG) in a Microsoft Exchange Server 2007 environment. You can create a DDG in Exchange Management Console (EMC) or in Exchange Management Shell (EMS). If the filter is complex, you must create the DDG in EMS. You can create the DDG by using the new-dynamicdistributiongroup command together with -RecipientFilter parameters. However, if you have more than one -and statement in a row, the RecipientFilter value is written as an invalid filter.

For example, you create a DDG that is named "testDDG" in EMS by using the following command:

New-dynamicdistributiongroup testDDG -RecipientFilter {((Alias -ne $null) -and (customattribute4 -eq 'active') -and (c -eq 'us'))}

Then, you locate the filter by using the EMC, or by using the following command:

get-dynamicdistributiongroup testDDG | fl RecipientFilter

After you run this command, the following filter is returned:

 (((Alias -ne $null -and
		  CustomAttribute4 -eq 'active') -and C -eq 'us') -and -not(Name -like
		  'SystemMailbox {*') -and -not(Name -like 'CAS_{*'))

To obtain the preview recipient list, you run the following command together with the filter that you obtained in the previous step:

get-recipient -RecipientPreviewFilter <the filter>

When you run this command, you do not receive the expected recipient list. Instead, you receive the following error message

You must provide a value expression on the right-hand side of the '-and' operator.