SMS and ConfigMgr: Query builder Values box cannot display large item list
If you are in a large site like me some queries will not show you what you need because you surpass the 2000 entries limit. The reg entry below will fix that.
Apparently they change the location for ConfigMgr. So if you are only running the ConfigMgr 2007 console you only need the second entry. but if you are using both like me you will need the whole works.
http://support.microsoft.com/kb/269201
APPLIES TO
- Microsoft Systems Management Server 2.0 Standard Edition
- Microsoft Systems Management Server 2.0 Service Pack 1
- Microsoft Systems Management Server 2.0 Service Pack 2
- Microsoft Systems Management Server 2.0 Service Pack 3
- Microsoft System Center Configuration Manager 2007
- Microsoft System Center Configuration Manager 2007 SP1
- Microsoft System Center Configuration Manager 2007 R2 with SP1
#################################################
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\AdminUI\QueryBuilder]
"ValueLimit"=dword:000124f8
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ConfigMgr\AdminUI\QueryProcessors]
"ValueLimit"=dword:000124f8
#################################################