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!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...