SMS: Query Value Operators for SMS 2.0

View products that this article applies to.

This article was previously published under Q202076

Expand all | Collapse all

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.