Splunk Search

how to search data created before last 14 Business days?

wangzhaoyu
New Member

I have a set of data with "submit date" like "2019-Jan-16 17:42:00". How can I get data submitted before 14 Business days? Thanks!

Tags (2)
0 Karma

mayurr98
Super Champion

Hi Try this simple query

index=your_index latest=-14d@d earliest=0 NOT (date_wday=saturday OR date_wday=sunday)

let me know if this helps!

0 Karma

dkeck
Influencer

HI,

do you want all data older than 14 days , or the data that came in on the 14th day before today?

0 Karma

wangzhaoyu
New Member

Hi,

I want the number of all data older than 14 Business days. thanks!

0 Karma

dkeck
Influencer

try index=your_index latest=-14d@d earliest=0 | stats count

for a simple count

0 Karma

wangzhaoyu
New Member

Does "latest=-14d@d" mean last Business days? or last natural days? thanks!

0 Karma
Get Updates on the Splunk Community!

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...

Introducing Splunk Enterprise 9.2

WATCH HERE! Watch this Tech Talk to learn about the latest features and enhancements shipped in the new Splunk ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...