{"id":929,"date":"2013-09-24T19:14:05","date_gmt":"2013-09-24T17:14:05","guid":{"rendered":"http:\/\/sccmfaq.wordpress.com\/?p=929"},"modified":"2013-09-24T19:14:05","modified_gmt":"2013-09-24T17:14:05","slug":"sccm-2012-extend-value-list-in-query","status":"publish","type":"post","link":"https:\/\/blog.hosebei.ch\/?p=929","title":{"rendered":"SCCM 2012 – Extend Value List in Query"},"content":{"rendered":"

Did you ever had the Problem, that when you created a query, let’s say you wanted to know, if the Software inventory has found a executable named zune.exe. So you go to your System Center 2012 Configuration Manager Console and create a new query by navigate to “MonitoringQueriesCreate Query”:
\n\"Create<\/a>The\u00a0“Create Query Wizard” appears, click on “Edit Query Statement”:
\n\"Create<\/a>
\nOn the tab “General” click on the star, and select “Name” from “System resource, and click “OK” thrice:
\n\"Query_List03\"<\/a>
\nThe Gerenal Tab should then Looks like this:
\n\"Query<\/a>
\nThen Change to the tab “Criteria”, also click on the star and create a new criterion by clicking on “Select…” and choose “Software Files” and “File Name”:
\n\"Query<\/a>
\nClick OK and choose the Operator, in my case a “is Like” Operator is good enough, because I want to see all executables starting with the letter Z:
\n\"Query<\/a>
\nBut now lets check, if there are some executables starting with letter Z before I use the query. I can simply click on “Value…” to see all the possible Values:
\n\"Query<\/a>
\nAs you might recognize on the Print Screen, the following Error Message appears:<\/p>\n

The operation was completed successfully, but the information list has been truncated to the maximum configured count of 2000 items.
\nFor Information about how to increase the Maximum result value, see Configuration Manager Help<\/p><\/blockquote>\n

This means, that not all values are shown in the following box, as I can see, there is no executable starting with Z, but those are only missing in this GUI, not in the database:
\n\"Query<\/a>
\nNow, you could look for the SCCM help, or just follow this simple step:
\nAdd a DWORD to the key HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Microsoft\\ConfigMgr10\\AdminUI\\QueryProcessors with Name “Valuelimit” and a Value of HEX 20000, on 32-bit Systems, the Key is HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\ConfigMgr10\\AdminUI\\QueryProcessors:
\n\"Registry<\/a>
\nAfter this, you’re able to see the whole list, and also the message isn’t shown anymore:
\n\"Query<\/a><\/p>\n

hope this helps \ud83d\ude42
\nMartin<\/p>\n","protected":false},"excerpt":{"rendered":"

Did you ever had the Problem, that when you created a query, let’s say you wanted to know, if the Software inventory has found a executable named zune.exe. So you go to your System Center 2012 Configuration Manager Console and create a new query by navigate to “MonitoringQueriesCreate Query”:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,31,36],"tags":[],"class_list":["post-929","post","type-post","status-publish","format-standard","hentry","category-general","category-query","category-setup"],"_links":{"self":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=929"}],"version-history":[{"count":0,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/929\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}