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 translations Article translations
Article ID: 973490 - View products that this article applies to.
Expand all | Collapse all

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.

CAUSE

This issue occurs because the filter parser misses a required separator.

RESOLUTION

To resolve this problem, install Update Rollup 1 for Exchange 2007 Service Pack 2.
971534 Description of Update Rollup 1 for Exchange Server Service Pack 2

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 973490 - Last Review: November 19, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Exchange Server 2007 Service Pack 2, when used with:
    • Microsoft Exchange Server 2007 Enterprise Edition
    • Microsoft Exchange Server 2007 Standard Edition
Keywords: 
kbqfe kbfix kbexpertiseinter kbhotfixrollup kbsurveynew KB973490

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com