Splunk Search

How to identify session from log based on request timestamp

moohkhol
New Member

Hi Guys,
My log message looks like below,

Time message
10:00 AM “log message 1”
10:10 AM “log message 2”
10:20 AM “log message 2”
10:41 AM “log message 3”
10:45 AM “log message 4”

11:20 AM “log message 5”
11:21 AM “log message 6”
11:22 AM “log message 7”
11:25 AM “log message 8”
11:45 AM “log message 9”
11:55 AM “ ….”
12:28 PM “…..”

I want above message to be grouped into 4 groups and print following,

Start_time 10:00 AM count 5
Start_time 11:20 AM count 6
Start_time 12:28 PM count 1

We are splitting message based on the any two consecutive record having time difference of more than 30 min.
Here, 10:45 AM and 11:20 AM is having 35 min, so breaking it and again we found at 11:55 AM, since difference between 11:55 AM and 12:28 PM is 33 Min.

Tags (1)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

That sounds like a job for transaction with maxpause=30m. See http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Transaction for in-depth info.

0 Karma
Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...