ConfigMgr : Query builder Values box cannot display large item list

August 24, 2010 at 12:16 pm in AdminUi, ConfigMgr, ConfigMgr 2007, ConfigMgr 2007 R2, ConfigMgr SP2, configmgr2007, ConfigMgr2007 R3, sccm, SCCM 2007, SCCM 2007 R2, SCCM 2007 R3, SCCM 2007 SP2, sccm2007 by Kenny Buntinx [MVP]

This is still an old one , but I can imagine some admins are still freaking out when seeing this .

In Microsoft System Center Configuration Manager (SCCM) 2007 , when trying to build a query that contains add/remove programs , most of the times it does not gives you the complete list. To solve this , you need to do the steps below :

In Microsoft System Center Configuration Manager (SCCM) 2007, find the registry key below :

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

ValueLimit is a registry entry under the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ConfigMgr\AdminUI\QueryProcessors registry subkey.
ValueLimit should be a dword value. The value signifies how many items are returned when the user clicks the values button in the criterion dialog box. This is an optional value. The default value is 2000 if no key exists. If users want to override the default value, they can create the registry key.

 

Hope it Helps ,

Kenny

Tweet about this on TwitterShare on FacebookShare on Google+Share on LinkedInPin on Pinterest