Splunk Search

Calculating difference between two strftime fields

jason_hotchkiss
Communicator

Hello Splunkers:

I'm looking to determine how many days file is out of date.

I have two strftime fields and values:

x = 1612285190.000
y = 1612303190.000000

I need to calculate the number of days between x and y, something like x - y = z.  

I tried: 
| eval z=x-y 

y calculates to -18000.00

I tried converting this using:
| eval x=strftime(z, "d%") and I get 31.  Which seems to be the 31st day of the month.  

Thanks in advance.

Labels (2)
0 Karma
1 Solution

scelikok
SplunkTrust
SplunkTrust

Hi @jason_hotchkiss,

You are very close, you can achieve this in two ways;

This will give you days;
| eval z=round((x-y)/86400,0)
This will give you timeformatted;
| eval z=tostring(x-y,"duration")

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.

View solution in original post

0 Karma

scelikok
SplunkTrust
SplunkTrust

Hi @jason_hotchkiss,

You are very close, you can achieve this in two ways;

This will give you days;
| eval z=round((x-y)/86400,0)
This will give you timeformatted;
| eval z=tostring(x-y,"duration")

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.
0 Karma

jason_hotchkiss
Communicator

Awesome, thank you!

Tags (1)
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...

Move CrowdStrike FDR ingestion to Data Inputs with a guided migration

CrowdStrike Falcon Data Replicator data is essential for security investigations, detections, and response. It ...

Make Your Machine Data AI-Ready in Splunk

Every team is getting ready for AI agents.    Watch On-Demand   In this Tech Talk, Splunk platform specialists ...