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

[ttchorz]

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

[Jeremiah]

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=*