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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...