Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


More information

When you query the Exchange Message Tracking class, the only way to return the correct results is to use the where not <property> = <value> query. Any other valid operators do not return any results. There are several different valid operators for the following queries:
!=
<>
where not <property> = <value>
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.

↑ Back to the top


Keywords: KB824114, kbbug, kbnofix

↑ Back to the top

Article Info
Article ID : 824114
Revision : 4
Created on : 10/25/2007
Published on : 10/25/2007
Exists online : False
Views : 248