Splunk Search

How to detect events logged 15 minutes apart in our heartbeat log?

mangelastro
Observer

We have a heartbeat service that runs every minute recording the following timestamp information:

Heartbeat: 2020-09-21T13:50:00.3031757-06:00

I'm hoping to detect events that take 15 minutes between the current timestamp and the last timestamp. 

This indicates that a server restart has happened.

Basically: 

Heartbeat: 2020-09-21T13:50:00.3031757-06:00 - Heartbeat: 2020-09-21T13:35:00.3031757-06:00

Does anyone know how I could record this?  

Thanks

 

 

 

Labels (2)
Tags (1)
0 Karma

to4kawa
Ultra Champion

 

index=_internal | head 1 | fields _raw _time | eval _raw="Heartbeat: 2020-09-21T13:50:00.3031757-06:00 - Heartbeat: 2020-09-21T13:35:00.3031757-06:00"
| rex max_match=0 "Heartbeat: (?<time>\S+)"
| eval time=mvmap(time,strptime(time,"%FT%T.%7Q%:z"))
| streamstats range(time) as duration window=1
| where duration >= 900

 

0 Karma

mangelastro
Observer

Thanks for the information?  do you know how I can determine this data based on the most recent entry and the second most recent entry?  

for example

eval _raw="Heartbeat current Entry"-  "Heartbeat previous entry"

 

Also when I try your suggestion I'm getting an eval error

Error in 'eval' command: The 'mvmap' function is unsupported or undefined.

 

Thanks again for your help!

 

 

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...