Getting Data In

How can I achieve the query for retrieving data for a particular time for the last 6 days?

Subarna
Explorer

How can I achieve the query for retrieving data for a particular time for the last 6 days? Suppose I want to get the data for last 6 days from time 12.00 A.M to 4.00 P.M. Please help on the same

Labels (1)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @Subarna,

you have to run a search for the full period adding a filter on the hosu, something like this:

index=your_index earliest=-6d@d latest=@d (date_hour>11 date_hour<17)
| ...

if you haven't date _hour, you have to extract it:

index=your_index earliest=-6d@d latest=@d 
| eval date_hour=strftime(_time,"%H")
| where date_hour>11 AND date_hour<17
| ...

Ciao.

Giuseppe

0 Karma
Get Updates on the Splunk Community!

Index This | What’s a riddle wrapped in an enigma?

September 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

BORE at .conf25

Boss Of Regular Expression (BORE) was an interactive session run again this year at .conf25 by the brilliant ...

OpenTelemetry for Legacy Apps? Yes, You Can!

This article is a follow-up to my previous article posted on the OpenTelemetry Blog, "Your Critical Legacy App ...