SMS: Query Value Operators for SMS 2.0 (202076)
The information in this article applies to:
- Microsoft Systems Management Server 2.0
This article was previously published under Q202076 SUMMARY
Systems Management Server (SMS) 2.0 provides Query functionality from the Microsoft Management Console (MMC) SMS Administrator. The WBEM Query language supports the following value operators:
- IN ([value1], [value2], [value . . .])
- IN (subselect)
- BETWEEN ([value1] AND [value2])
For example, t1.SiteCode BETWEEN 'aaa' AND 'ccc' - NOT IN ([value1], [value2], [value . . .])
- NOT IN (subselect)
- UPPER ([expr])
- LOWER ([expr])
- NULL ([expr] is NULL)
- NOT NULL ([expr] is not NULL)
- DATEPART ([part], [date 1]) (part = "mm","dd","yy","hour","minute","second","ms")
= (equal)
< > or != (not equal)
< (greater than)
> (less than)
REFERENCES
For a complete reference of the WQL that the SMS Provider supports, refer to the "Using WBEM Query Language with Systems Management Server" section in the SMS Toolkit.
| Modification Type: | Minor | Last Reviewed: | 6/14/2005 |
|---|
| Keywords: | kbinfo KB202076 |
|---|
|