Splunk Search

Change maxresulttows for outputlookup?

ddrillic
Ultra Champion

When running an inline search the results limit is high as we have in limits.conf the following.

[searchresults]
maxresultrows = 50000000
# Defaults to 50000

However, when we schedule the same search and direct the output to a lookup table via outputlookup <filename>, the lookup file is only of 50K lines.

Can we change this value?

lguinn2
Legend

I don't understand these terms. What does "search jobs server" mean? What does "batch head" mean?

The outputlookup command runs on the search head (or standalone Splunk instance) where the search is executed.
However, other commands ALSO have maxresultrows, such as the stats command. The use of any of these commands prior to the outputlookup command would mean that the number of results overall would be constrained.

Perhaps you should consider multiple searches, each with its own outputlookup. Perhaps you could run one search per host, for example. Just be sure to name each outputlookup file differently. You might consider using the foreach command (or maybe the map command) to accomplish this.

Perhaps posting your actual search would give the community more ideas about how to help.

0 Karma

ddrillic
Ultra Champion

The query is something like - any search | table field1 | outputlookup field1.

0 Karma

ddrillic
Ultra Champion

We have these batch heads, jobs servers, which are SHs that run saved searches and their configurations is different than the SHs. So, apparently, we need so sync their configurations with the SHs.

We use something in the spirit of Scheduled searches with a jobs server and pooling

0 Karma

lim2
Communicator

ddrillic, Iguinn2, I am trying to do the |inputlookup largefile.csv |outputlookup largefile, as per https://dev.splunk.com/enterprise/docs/developapps/kvstore/migrateyourappfromusingcsv/ . The csv file is +200MB with +1.5mil rows, to try reduce the bundle size. is it stable or advisable to do maxresultrows = 5000000 ?

0 Karma

ddrillic
Ultra Champion

Our Sales Engineer told me -

-- The issue is that the search head isn’t executing the search, your search jobs server is.
You need to modify that stanza on the jobs server.

Does it mean that every command which involves outputlookup <filename> runs on the batch head?

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...