topic Re: How can I search a lookup table for rows that match an input string in any field? in Splunk Search

How can I search a lookup table for rows that match an input string in any field?

matstap — Tue, 06 Feb 2018 19:25:38 GMT

I need to search a lookup table for rows that match an input string in any field.

I've tried |inputlookup...... | search $searchKey$ but this returns no results.

How do I do this?

Re: How can I search a lookup table for rows that match an input string in any field?

micahkemp — Tue, 06 Feb 2018 19:28:23 GMT

| inputlookup <lookup name> WHERE <fieldname>=<value>

Your | search version would probably work if you did | search <fieldname>=<value>, but it's better to include the filter in inputlookup itself.

Re: How can I search a lookup table for rows that match an input string in any field?

micahkemp — Tue, 06 Feb 2018 20:39:33 GMT

I see I didn't really answer your question. I will revisit this in a few.

Re: How can I search a lookup table for rows that match an input string in any field?

matstap — Tue, 06 Feb 2018 20:53:05 GMT

Is there a way to do this without specifying the field? I just want to pass in a string x and if in one row FieldA=x and in another row FieldB=x, it will return both rows

Re: How can I search a lookup table for rows that match an input string in any field?

micahkemp — Tue, 06 Feb 2018 21:18:23 GMT

Try this:

| inputlookup <lookup>
| foreach * [eval matched=if(matched="YES" OR <<FIELD>>="searchkey", "YES", "NO")]
| search matched="YES"
| fields - matched

Re: How can I search a lookup table for rows that match an input string in any field?

matstap — Wed, 07 Feb 2018 20:34:47 GMT

That's what I'm looking for. Thanks