“Query builder Values box can’t display large item list”-fix works for ConfigMgr 2012

maxresults-01When pressing on the Values box in the Query builder while creating a Collection in ConfigMgr you might run into an error that states that “The operation has completed successfully, but the information list has been truncated to the maximum configured count of 2000 items.” For SMS 2.0 and ConfigMgr 2007 there was a registry key that you were able to configure to see more items.

 

The fix like describes in KB269201 works also for ConfigMgr 2012.

When for instance creating a query that you want to look for a value that corresponds to an item in the Installed Software – ARPDisplay Name list you might see a limited list like shown below.

Limited results
Limited results

For 32bits ConfigMgr 2012 Consoles on 64bits go to the following registry key:

  • HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftConfigMgr10AdminUIQueryProcessors

Otherwise go to the following registry key:

  • HKEY_LOCAL_MACHINESOFTWARE MicrosoftConfigMgr10AdminUIQueryProcessors

Add a DWORD value for ValueLimit and set it to a, for you appropriate value. (eg. decimal value 10000)

After adding and changing the value and restarting the ConfigMgr Console you are able to see all values.

Full list of results
Full list of results

Comments

Total
0
Shares
2 comments
  1. For my 32-bit SCCM 2007 console on Win 8 64-bit I had to update HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ConfigMgr\AdminUI\QueryProcessors, not Wow6432Node.

Leave a Reply

Your email address will not be published. Required fields are marked *

Previous Post

How to run Powershell scripts with a Service Account to access ConfigMgr 2012 SP1

Next Post

Quick tips + note to myself about CMTrace.exe in ConfigMgr 2012

Related Posts
Total
0
Share