Splunk IT Service Intelligence

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!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...