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!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...