Splunk Search

How to search for an event that has not occurred in 1 day

MeMilo09
Path Finder

Hello All,

Anyone out there know how I can search for an event that is supposed to occur within 24 hours but has not? 
Example:

1 - Invite is sent, if invite is not marked received in 24 hours it is a failure. 

So, lets say --- invite was sent 11/14/21 and it is received on 11/16/21 this is a failure. 

The start time would not be now() or relateive_time function because the start time would be the time the invite was sent. 

Any help is greatly appreciated. 

Labels (2)
Tags (1)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @MeMilo09,

assuming that there's a common key to use to correlate events and there are an event with status="Invite sent" and another one with status="Invite received", you could run something like this (to adapt to your real situation):

index=orders (Status="Invite sent" OR Status="Invite received")
| stats 
     dc(Status) AS dc_status 
     values(Status) AS Status 
     earliest(_time) AS earliest 
     latest(_time) AS latest 
     BY Invite_Id
| eval 
     Invite_Status=if(dc_status=1 AND Status="Invite sent","Invite sent But Not Received",if(dc_status=2 AND (latest-earliest>172800),"Invite sent But Received Late","Invite Sent and Received"),
     Invite_Sent_Date=strftime(earliest,"%Y-%m-%d %H:%M:%S"), 
     Invite_Received_Date=dc_status=1 AND Status="Invite sent","Not Received",strftime(latest,"%Y-%m-%d %H:%M:%S"))
| table Invite_Id Invite_Status Invite_Sent_Date Invite_Received_Date

 Ciao.

Giuseppe

View solution in original post

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @MeMilo09,

assuming that there's a common key to use to correlate events and there are an event with status="Invite sent" and another one with status="Invite received", you could run something like this (to adapt to your real situation):

index=orders (Status="Invite sent" OR Status="Invite received")
| stats 
     dc(Status) AS dc_status 
     values(Status) AS Status 
     earliest(_time) AS earliest 
     latest(_time) AS latest 
     BY Invite_Id
| eval 
     Invite_Status=if(dc_status=1 AND Status="Invite sent","Invite sent But Not Received",if(dc_status=2 AND (latest-earliest>172800),"Invite sent But Received Late","Invite Sent and Received"),
     Invite_Sent_Date=strftime(earliest,"%Y-%m-%d %H:%M:%S"), 
     Invite_Received_Date=dc_status=1 AND Status="Invite sent","Not Received",strftime(latest,"%Y-%m-%d %H:%M:%S"))
| table Invite_Id Invite_Status Invite_Sent_Date Invite_Received_Date

 Ciao.

Giuseppe

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @MeMilo09,

good for you, see next time!

ciao and happy splunking!

Giuseppe

P.S.: Karma Points are appreciated 😉

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...