Lookup Max Match

[obhatti]

How can I change the limit on the number of results matched per lookup value? I have a lookup value which has 183 matches in the lookup table, but only 100 results are returning.

Thank you in advance.

[somesoni2 · Accepted solution]

For you lookup table file, create a lookup definition (from Manager -> Lookups -> Lookup Definitions). give it same sharing permissions as the lookup table file and in the "Advanced options" provide appropriate value.

[chitreshakumar]

I tried with the steps u provided .But it doesn't seem to work for me.
I have a lookup value which has 668 matches in the lookup table, but only 100 results are returning.

[obhatti]

Thanks somesoni2. That worked!

[benton]

Worth noting that in Splunk 6.5.2 there is a typo. When you edit the lookup it says: "Max Matches: Enter a number from 1-1000 to specify the maximum number of matches for each input lookup value. If time-based, default is 1; otherwise, default is 1000." This seems to be incorrect in 6.5.2. It is still defaulted to 100.