Splunk Search

How to compare two fields from two indexes and display data when there is a match?

ttchorz
Path Finder

Hi,

I want to compare two fields from two indexes and display data when there is a match.

indexA contains fields plugin_id, plugin_name
indexB contains fields id, solution

I am trying to display plugin_id, plugin_name, solution FOR EVERY RECORD that meets plugin_id=id

So far I have tried these searches but no luck:

(index=indexA OR index=indexB) plugin_id="*" id="*" | where like(plugin_id, id) | table plugin_id, plugin_name, solution

and

(index=indexA OR index=indexB) plugin_id="*" id="*" | where plugin_id=id | table plugin_id, plugin_name, solution
0 Karma

Jeremiah
Motivator

This search should combine the events from the two indexes together by their ID fields, then finds only entries where both id fields are present.

 (index=indexA plugin_id=*) OR (index=indexB id=*) | eval match_id=coalesce(id,plugin_id) | stats values(*) AS * by match_id | search plugin_id=* id=*
0 Karma
Get Updates on the Splunk Community!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...