Microsoft KB Archive/202042

= SMS: How to Get Query Operator to Find Items with NULL Values =

Article ID: 202042

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q202042



SYMPTOMS
In Systems Management Server 2.0, the query operator is not able to find items whose value is NULL.



WORKAROUND
When typing values in Systems Management Server 2.0 to query on, some value must be specified. If your intent is to find all computers that have a NULL value for a particular instance, an error will be generated when trying to set up the query. To get the query to operate properly, type a space character in the field. This will act that same as a NULL entry.



STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0.

Additional query words: prodsms

Keywords: kbbug kbpending kbquery KB202042

-

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

© Microsoft Corporation. All rights reserved.