Splunk Search

Join by time range

stwong
Communicator

Hi all,

 

Possible to join 2 search results like following?

 

Set 1:

_time 

field1

field2

field3 (common field)

 

Set 2:

_time  

fieldA (multiple values, contains start/end time) 

fieldB 

field3 (common field)

 

Then join with common field3, together with:

 

fieldA (start) < _time (Set1) < fieldA (end)

 

Thanks a lot.

Regards

/stwong

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Rename _time in query 2 as part of the join, then you will be able to do your comparison / filter after the join

0 Karma

stwong
Communicator

Thanks.  Seems if join first with common field3,  unable to do filter afterwards. Would you advise how?  Sorry for the newbie question.

Thanks.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

@stwong I don't understand what you mean. Perhaps if you gave some concrete examples of your queries and data we might be able to help more.

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...