Alerting

How can I use cron to schedule for quarterly reports at certain intervals?

dmenon84
Path Finder

Hi,

I want to schedule the report at following intervals

9/1 - 11/30
12/1 - 2/28(29) (this is an odd one because of leap years)
3/1 - 5/31
6/1 - 8/31

How can I do this using the cron schedule? Thanks in advance!

Thanks,
Deepthi

0 Karma

somesoni2
Revered Legend

Assuming you want your quarterly report to run as following:

Quarter range     ###   Date on which Report should be run
9/1 - 11/30       ###  12/01 
12/1 - 2/28(29)   ###  03/01
(this is an odd one because of leap years)
3/1 - 5/31        ###   06/01
6/1 - 8/31        ###   09/01

Try the cron schedule as this (running every quarter, as above schedule, at 3 AM in the morning

0 3 1 3,6,9,12 *

Your search's time range would be -3mon@mon to @mon.
See the corresponding scheduled data here: https://crontab.guru/#0_3_1_3,6,9,12_* (click on next hyperlink to see more dates)

0 Karma

FrankVl
Ultra Champion

Is it OK to run the report at midnight of the first day of the next quarter? That would translate to 0 0 1 */3 *.

Then you just need to define the timerange for your report correctly, I guess earliest=-3mon@mon latest=@mon should do the trick?

0 Karma
Get Updates on the Splunk Community!

Unlock New Opportunities with Splunk Education: Explore Our Latest Courses!

At Splunk Education, we’re dedicated to providing top-tier learning experiences that cater to every skill ...

Technical Workshop Series: Splunk Data Management and SPL2 | Register here!

Hey, Splunk Community! Ready to take your data management skills to the next level? Join us for a 3-part ...

Spotting Financial Fraud in the Haystack: A Guide to Behavioral Analytics with Splunk

In today's digital financial ecosystem, security teams face an unprecedented challenge. The sheer volume of ...