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!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...