Splunk Search

Automatic lookup failing

ipops
Path Finder

I have a lookup working when I use "lookup" manually in my search.alt text I cannot seem to get this working as an automatic lookup though.

This search works and returns the lookup fields

sourcetype=ivrdata | WHERE IVR_Message="Phone" | rename IVR_Value AS areacode | rex field=areacode mode=sed "s/(\d{3})(\d{3})(\d{4})/\1-\2/g" | table areacode | lookup AreaCodeLookup areacode

This search simply returns the areacodes but all other fields (city, region, etc) are blank

sourcetype=ivrdata | WHERE IVR_Message="Phone" | rename IVR_Value AS areacode | rex field=areacode mode=sed "s/(\d{3})(\d{3})(\d{4})/\1-\2/g" | table areacode city region latitude

My automatic lookup is defined as
AreaCodeLookup areacode AS phone_no OUTPUTNEW city country latitude AS _lat longitude AS _lng region

What am I missing here to get automatic lookup working?

Tags (1)
0 Karma

sundareshr
Legend

It appears your lookup is dependent on a field that has not been extracted. Add areacode to field extraction on your search head and try the auto lookup. The reason it works in the GUI is because you have a rex to extract the field before the lookup

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...