Splunk Search

Multiple Lookups from Sourcetype

paulf
Explorer

Hi,
Is it possible to perform a more than 1x lookup on a number of fields?

I have 2x IP fields, one is a source ip another a destination ip.

I have the following in my props.conf.

[radware]
LOOKUP-rdns = dnsLookup ip AS rad_attack_target_ip OUTPUTNEW host AS rad_attack_target_host
LOOKUP-rdns = dnsLookup ip AS rad_attack_source_ip OUTPUTNEW host AS rad_attack_source_host

The lookups are working, however only one of them. It is always the last one that works. For instance with the above configuration the hostnames will appear for rad_attack_source_host but not for the rad_attack_target_host.

If i swap the lookups around, the rad_attack_source_host will have no data, but the rad_attack_target_host will.

Thanks
Paul

Tags (1)
1 Solution

Ayn
Legend

First thing I spot is that you don't have unique identifiers for your LOOKUP definitions. Both the first and second one is called "LOOKUP-rdns". These identifiers need to be unique, because that's how Splunk keeps track of them. So, if you have two with the same name, the second one is most likely "overwriting" the first. So if you call them something like "LOOKUP-rdns1" and "LOOKUP-rdns2" you might solve your problem. (or at least we can go on to the next step of troubleshooting 😉 )

View solution in original post

Ayn
Legend

First thing I spot is that you don't have unique identifiers for your LOOKUP definitions. Both the first and second one is called "LOOKUP-rdns". These identifiers need to be unique, because that's how Splunk keeps track of them. So, if you have two with the same name, the second one is most likely "overwriting" the first. So if you call them something like "LOOKUP-rdns1" and "LOOKUP-rdns2" you might solve your problem. (or at least we can go on to the next step of troubleshooting 😉 )

paulf
Explorer

Hi,

Thanks! that has resolved my issue...

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to January Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...