Splunk Search

How to search for a keyword2 with in 10 minutes after keyword1 occured in events?

SapthagiriAavik
Explorer

I have a events log something like this,

2018-06-29 03:34:23.090 -5 Thread-55 CM 6107 1 Content Manager is unable to process the request.

2018-06-29 03:39:23.090 -5 Thread-85 CM 6186 1 Event Solution Assigned URL http://*";

If this keyword1 occurred "Content Manager is unable to process the request" ,then I want to search for this keyword2 " Event Solution Assigned URL http://*"; within 10 minutes. if keyword2 not occurred within 10 minutes I want to send an alert

Tags (2)
0 Karma

woodcock
Esteemed Legend

Like this:

Your Search For both Events Here
| reverse
| streamstats count(eval(searchmatch("Content Manager"))) AS sessionID
| eventstats first(_time) AS start_time BY sessionID
| eval secondsaway = _time - start_time
| where secondsaway < (10 * 60)
0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  &#x1f680; Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

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