Splunk ITSI

compare two different fields from different indexes and return a third field if matched

ialahdal
Path Finder

What I am trying to achieve is as follows:
Index=1 client_ip=10.10.10.10 host=Test1
Index=2 ip=10.10.10.10 port=7551

Based on the above I'd like to run a search that will return values of "host" and "port" in a table if client_ip=ip

I have tried join index=1 client_ip=* |rename client_ip as ip|join type=inner ip [search index=2 |stats values(ip) by host]

Labels (1)
0 Karma

to4kawa
Ultra Champion
(index=1 client_ip=*) OR (index=2 ip=*)
| eval IP=coalesce(ip,client_ip)
| stats values(host) as host values(port) as port dc(index) as check by IP
| where check > 1

Hi, @ialahdal
please try this.

Get Updates on the Splunk Community!

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...

Splunk AppDynamics Agents Webinar Series

Mark your calendars! On June 24th at 12PM PST, we’re going live with the second session of our Splunk ...

SplunkTrust Application Period is Officially OPEN!

It's that time, folks! The application/nomination period for the 2025 SplunkTrust is officially open! If you ...