Query builder Values box cannot display large item list

When you create a query in Systems Management Server (SMS) 2.0, the Values box in the query builder may be empty. This may occur if the hotfix for Q245648 is installed, and there is either a very large value (approximately 9,500; the actual number varies based on available memory) or a value of 0 (a value of 0 requests that all records be returned) specified in:

HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\AdminUI\QueryBuilder\ValueLimit

The hotfix for Q245648 (both for Service Pack 1 and Service Pack 2) allows for more than 2,000 records to be listed in the query builder criteria section. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

245648 (http://support.microsoft.com/kb/245648/ ) Values list from Query Builder not always sorted and limited to first 2000 records


RESOLUTION:

Registry subkey information

In SMS 2.0 and in SMS 2003, the registry key is as follows:

HKEY_LOCAL_MACHINE\SMS\AdminUI\QueryBuilder\ValueLimit

In Microsoft System Center Configuration Manager (SCCM) 2007, the registry key is as follows:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ConfigMgr\AdminUI\QueryProcessors\ValueLimit