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
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

REGISTER NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If ...

Observability | Use Synthetic Monitoring for Website Metadata Verification

If you are on Splunk Observability Cloud, you may already have Synthetic Monitoringin your observability ...

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...