SCCM Query Builder results limited to 2000

SCCM Query Builder results limited to 2000

While building Queries in SCCM Query Builder, you will sooner or later run into an issue where it will only return 2000 items. This is a legacy setting that goes back to SMS 2.0 where the server/PC would literally run out of memory to return more than that. Head over to Peter Daalmans’s Blog for the complete answer, but here’s a snippet in case his blog goes down….

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

  • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ConfigMgr10\AdminUI\QueryProcessors

Otherwise go to the following registry key:

  • HKEY_LOCAL_MACHINE\SOFTWARE \Microsoft\ConfigMgr10\AdminUI\QueryProcessors

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s