Reporting

How to generate a report for previous month and have it emailed?

bayman
Path Finder

I would like a saved search to be ran on the 1st of each month with data from the previous month and have it emailed to me. I see that under Save As -> Alert, I can choose Scheduled and "Run every month" but where do I I tell it to run the search for the previous month?

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi bayman,
don't use an alert, use a scheduled report:

  1. run your search using as time period last_month,
  2. save it as a report
  3. schedule this report to be run the 1st of each month
  4. configure an action to send an email

Bye.
Giuseppe

0 Karma

kmorris_splunk
Splunk Employee
Splunk Employee

In you search, you could use earliest and latest. For example:

index=yourindex sourcetype=yoursourcetype earliest=-1mon@mon latest=@mon

You could also set the time selector to Previous Month before saving the Alert.

Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

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, ...