Splunk Search

earliest - latest question

kstanley
New Member

I'm a newby so forgive my ignorance with Splunk. I'm running this real time and only want it to run from 6:30am to 10pm mon-sat. This is what I have on the end and it's not working. Any suggestions will be greatly appreciated.

earliest=@d+6h+30m latest=@d+22h date_wday!=sunday

Tags (2)
0 Karma

DalJeanis
Legend

1) It's not clear whether you are saying you want to ignore data that is not in that time frame, or you want to turn the search off if the wall clock is not in that time frame?

2) Your concentration on such a wide amount of time suggests to me that a realtime search is inappropriate to what you are actually doing. So, what are you actually doing?

0 Karma

somesoni2
Revered Legend

Are you running it as a 'real time search' and you want that search to run for specified duration? OR you're running a regular search and just want data from specified period to be included?

0 Karma

cmerriman
Super Champion

try this:

|eval keep=if((_time>=relative_time(_time,"@d+6h+30m") AND _time<=relative_time(_time,"@d+22h")) AND date_wday!="sunday",1,0)|search keep=1
0 Karma

kstanley
New Member

Thank you, I'll give that a try

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!

Event Series: Splunk Observability Metrics Cost Optimization

Balancing Scale and Spend: Gaining Control Over High-Volume Metrics in Splunk Observability Cloud As ...

Kick the Tires Before You Commit: A Hands-On Tour of the Splunk Observability Cloud ...

Evaluating an enterprise observability platform usually goes like this: fill out a form, get a free trial with ...

Deep insights, no barriers: Splunk Observability Cloud Free Edition

As software delivery cycles continue to accelerate, observability shouldn’t be a luxury — it should be a ...