Splunk IT Service Intelligence

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

Path Finder

What I am trying to achieve is as follows:
Index=1 client_ip= host=Test1
Index=2 ip= 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

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!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...