SMS: Query Value Operators for SMS 2.0
Article ID: 202076
Article Last Modified on 10/27/2006
APPLIES TO
- Microsoft Systems Management Server 2.0 Standard Edition
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.
Additional query words: prodsms sms20 queries
Keywords: kbinfo KB202076