Microsoft KB Archive/824114

= You Can Only Run a WQL Query When a Property Is Not Equal to a Value =

Article ID: 824114

Article Last Modified on 10/25/2007

-

APPLIES TO


 * Microsoft Exchange Server 2003 Enterprise Edition
 * Microsoft Exchange Server 2003 Standard Edition

-





SUMMARY
This article contains information about the behavior of the Exchange Message Tracking class in Windows Management Instrumentation (WMI) Query Language (WQL). When you run a query against WMI, and you query the Exchange Message Tracking class (exchange_messagetrackingentry), you must search for results when a property is not equal to a value. When you run a query for a property that is not equal to a value, the query returns correct results. This only applies to the Exchange Message Tracking class (exchange_messagetrackingentry) and does not return results for any other Exchange classes.



MORE INFORMATION
When you query the Exchange Message Tracking class, the only way to return the correct results is to use the where not =  query. Any other valid operators do not return any results. There are several different valid operators for the following queries:

!=

<>

where not = 

For example, if you use the WMI Tester tool wbemtest to submit the following queries, the queries do not return any results:

select * from exchange_messagetrackingentry where entrytype != 1028

select * from exchange_messagetrackingentry where entrytype <>1028

The following query is the only query that uses one of the 3 previous operators that returns the correct results:

select * from exchange_messagetrackingentry where not entrytype = 1028

Note These queries can also be executed programmatically, and are not limited to wbemtest.

Keywords: kbnofix kbbug KB824114

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.