Splunk Search

Accounting for weekends and holidays

AlexeyPy
Engager

I'm trying to come up with a method of accounting for weekends and holidays. Tell me, how should I implement this algorithm?
Real case: we need to catch response on the application after 2 working days subject to weekends and holidays.

There is the idea to implement it with a lookup, however, will have to manually affix the holidays every year. I would like to automate this process completely.

Tags (2)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi AlexeyPy,
for week-ends you can add to your searches

date_wday="sunday" OR date_wday="saturday"

instead to manage holydays the only way is to create a lookup containing holyday dates and use it to filter your searches.

your_search (date_wday="sunday" OR date_wday="saturday" OR [ | inputlookup holydays.csv | fields date ] )

putting attention on the date format that must be the same for _time and your lookup.

Bye.
Giuseppe

Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...