Splunk Search

how to snap to time unit of 5 minutes

taozi021
Explorer

for example: if the current time 5:23:20 PM, how can i get the time 4:55:00 PM. and if the current time 5:26:12 PM, how can i get time 5:20:00 PM, and so on

i know splunk provide one minute time uint. for example -5m@m. if there is 5 minute time unit, or some alternative way to get same result?

Tags (1)

charleswheelus
Path Finder

gkanapathy
Splunk Employee
Splunk Employee

I don't think there is an straightforward way. However, you can express it first by finding out how many seconds are in your "snap-to" unit. For something like earliest=-15m@5m latest=-10m@5m, you can do

sourcetype=mysourcetype [ stats count | eval earliest=5*60*(floor(now()-(15*60)/(5*60))) | eval latest=5*60*(floor(now()-(10*60)/(5*60))) | fields earliest latest ]
0 Karma

gkanapathy
Splunk Employee
Splunk Employee

I'm pretty sure he wants to snap the time range of a search to the nearest 5m rather than the nearest 1m or 1d or 1h unit.

0 Karma

Genti
Splunk Employee
Splunk Employee

if i have understood you correctly you want to set the timeframe for a search. If so you can use the info found here.
This here is for absolute timeframe.
Note, you can even use epoch time if needed.

Hope this helped.
.gz

Lowell
Super Champion

Your examples don't seem to be consistent. Also, what's the context you are trying to do this in? Are you trying to set the timeframe for a search, or are you talking about date manipulation using fields with a search?

0 Karma
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...