Tech Community Live: Endpoint Manager edition
Jul 21 2022, 08:00 AM - 12:00 PM (PDT)
SOLVED

How do I increase the 2000 limit in the query builder?

%3CLINGO-SUB%20id%3D%22lingo-sub-3370860%22%20slang%3D%22en-US%22%3EHow%20do%20I%20increase%20the%202000%20limit%20in%20the%20query%20builder%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3370860%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20query%20rule%20to%20include%20computers%20with%20a%20particular%20executable%20filename%20(Software%20Files.File%20Name)%20and%20get%20a%20warning%20about%20the%20information%20list%20being%20truncated%20to%202000%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20time%20of%20typing%20I%20have%20not%20been%20successful%20trying%20to%20find%20out%20how%20to%20increase%20this%20limit.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20extremely%20we%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3370860%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECM%20current%20branch%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3371416%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20increase%20the%202000%20limit%20in%20the%20query%20builder%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3371416%22%20slang%3D%22en-US%22%3EWhat%20does%20you%20query%20look%20like%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3378899%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20increase%20the%202000%20limit%20in%20the%20query%20builder%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3378899%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9198%22%20target%3D%22_blank%22%3E%40Garth%20Jones%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Garth%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20response.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20convinced%20I%20explained%20my%20issue%20very%20well.%26nbsp%3B%20I%20haven't%20got%20as%20far%20as%20completing%20the%20query%2C%20it's%20in%20the%20Criterion%20Properties%20I%20am%20seeing%20the%202000%20limit%20I%20want%20to%20extend.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20the%20screenshot%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Criterion%20Properties.png%22%20style%3D%22width%3A%20397px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371811i6D1E05CBB9788936%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Criterion%20Properties.png%22%20alt%3D%22Criterion%20Properties.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20used%20a%20configuration%20baseline%20to%20get%20the%20information%20(where%20a%20particular%20path%20is%20found%20on%20a%20computer)%20so%20I%20have%20the%20information%20I%20need%2C%20but%20I%20was%20hoping%20to%20get%20the%20computers%20with%20said%20path%20into%20a%20device%20collection.%26nbsp%3B%20It's%20not%20essential%2C%20but%20it's%20also%20not%20the%20first%20time%20I've%20seen%20this%20limit%20and%20I'd%20like%20to%20increase%20it%20for%20other%20tasks%20in%20the%20future.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Martin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3380067%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20increase%20the%202000%20limit%20in%20the%20query%20builder%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3380067%22%20slang%3D%22en-US%22%3ENo.%20you%20can't%20increase%20that%20limit.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3380118%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20increase%20the%202000%20limit%20in%20the%20query%20builder%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3380118%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9198%22%20target%3D%22_blank%22%3E%40Garth%20Jones%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20a%20very%20useful%20dialog%20box!%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%40740916ADE2D54AA0783BBB74D501083F%2Fimages%2Femoticons%2Funamused_40x40.gif%22%20alt%3D%22%3Aunamused%3A%22%20title%3D%22%3Aunamused%3A%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20help%20though%2C%20at%20least%20I%20won't%20waste%20any%20further%20time%20looking%20for%20a%20way%20to%20increase%20the%20limit.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to create a query rule to include computers with a particular executable filename (Software Files.File Name) and get a warning about the information list being truncated to 2000 items.

 

At time of typing I have not been successful trying to find out how to increase this limit.

 

Any help would be extremely we

4 Replies
What does you query look like?

@Garth Jones 

 

Hi Garth,

 

Thank you very much for your response.

 

I'm not convinced I explained my issue very well.  I haven't got as far as completing the query, it's in the Criterion Properties I am seeing the 2000 limit I want to extend.

 

Please see the screenshot attached.

 

Criterion Properties.png

 

I've used a configuration baseline to get the information (where a particular path is found on a computer) so I have the information I need, but I was hoping to get the computers with said path into a device collection.  It's not essential, but it's also not the first time I've seen this limit and I'd like to increase it for other tasks in the future.

 

Kind regards,

 

 

-Martin

best response confirmed by PurpleTentacle (New Contributor)
Solution
No. you can't increase that limit.

@Garth Jones 

Not a very useful dialog box! :unamused:

 

Thank you for the help though, at least I won't waste any further time looking for a way to increase the limit.