I want to compare two fields from two indexes and display data when there is a match.
indexA contains fields pluginid, pluginname
indexB contains fields id, solution
I am trying to display pluginid, pluginname, 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
(index=indexA OR index=indexB) plugin_id="*" id="*" | where plugin_id=id | table plugin_id, plugin_name, solution
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=*