Splunk Search

How to give time modifiers to run the search query from yesterday morning 5 am to today morning 5 am ?

rakesh_498115
Motivator

Hi All,

Can anyone help me on the time modifiers ... for giving the earliest and latest for yesterday morning 5 am to today morning 5 am.

earliest=-1d@5h latest=-0d@5h but this doesnt work

thanks.

Tags (1)
1 Solution

tom_frotscher
Builder

Hi,

try earliest=-1d@d+5h and latest=@d+5h

Greetings

Tom

View solution in original post

MuS
Legend

Hi rakesh_498115,

how about:

earliest=10/07/2014:05:00:00 latest=10/08/2014:05:00:00

if run today. See docs for more details http://docs.splunk.com/Documentation/Splunk/6.1.4/Search/Specifytimemodifiersinyoursearch

cheers, MuS

rakesh_498115
Motivator

I was looking for generic timestamp Mus. Thanks for ur reply.. 🙂

0 Karma

tom_frotscher
Builder

Hi,

try earliest=-1d@d+5h and latest=@d+5h

Greetings

Tom

rakesh_498115
Motivator

Great tom.. missed this + sign.. thanks 🙂

0 Karma
Get Updates on the Splunk Community!

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

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

Combine Multiline Logs into a Single Event with SOCK: a Step-by-Step Guide for ...

Combine multiline logs into a single event with SOCK - a step-by-step guide for newbies Olga Malita The ...