Splunk Search
Highlighted

Using extracted fields in automatic lookups

Explorer

I have a series of fields I've extracted using the GUI for a particular sourcetype. I've also set up a lookup table, definition, and automatic lookup using one of those fields. The automatic lookup is supposed to add a field from the lookup table. However, I cannot get it to work with fields that have been extracted using the GUI. Is there something I'm missing? Automatic lookups work just fine on sourcetypes with fields that have been automatically extracted (ie, they arrive at Splunk as "key=value" pairs and require no additional extraction).

Any hints?

0 Karma
Highlighted

Re: Using extracted fields in automatic lookups

Super Champion

Have you tested the lookup by applying it manually after a search that extracts the fields?

0 Karma
Highlighted

Re: Using extracted fields in automatic lookups

Super Champion

search | extract | lookup

0 Karma
Highlighted

Re: Using extracted fields in automatic lookups

Splunk Employee
Splunk Employee

First add an entry in $SPLUNK_HOME/etc/systems/local/transforms.conf:

[alookupexample]
filename=mycsvfile.csv

Then either restart splund or do a | extract reload=t then run a search like the one below:

somesearch | lookup alookupexample <oneofthefieldsyouextractedviagui> OUTPUT <oneofthefieldsinthelookup)inthelookup>

oneofthefieldsyouextractedviagui above needs to be the first column of the csv lookup

make sure you are looking at all the interesting fields on the right (blue) of the screen

After you've confirmed that that works put in the correct stanza inside of the props.conf file.

Highlighted

Re: Using extracted fields in automatic lookups

Path Finder

So, I ran the search manually with the lookup and I was able to match fields in the search with fields in the lookup, but the OUTPUT field was not...output. No dice. But, thanks.

0 Karma