Splunk Search

I'm trying to search between 2 indexes that correlates field value to return back certain fields.

payton_tayvion
Path Finder

I'm trying to search between 2 indexes that correlates field value to return back certain fields.

For example index a has the fieldname named src_ip and index b has a fieldname named src. The values are the same, but the fieldname are different. I want to use these values to correlate the data, but I want to also return field names that aren't in index a, but located in index b.

 

Here's my current quey.

 

index=a categories="media"
| where bytes_out > bytes_in 
| fields _time, cs_user, src_ip, cs_auth_group, cs_host, cs_method, status, bytes_in, bytes_out, cs_User_Agent
| eval src=src_ip
| join src
    [ search index=b 
    | fields log_subtype, cat]

 

Labels (2)
0 Karma

scelikok
SplunkTrust
SplunkTrust

Hi @payton_tayvion,

You should keep src field on subsearch in order to be able to join. Please try below;

index=a categories="media"
| where bytes_out > bytes_in 
| fields _time, cs_user, src_ip, cs_auth_group, cs_host, cs_method, status, bytes_in, bytes_out, cs_User_Agent
| eval src=src_ip
| join src
    [ search index=b 
    | fields src, log_subtype, cat]
If this reply helps you an upvote and "Accept as Solution" is appreciated.
0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...