Reporting

Sendemail command

andrey2007
Contributor

I use sendemail command in scheduled search which runs every 5 minutes .
search looks like
index=myindex user=* | table user host source| sendemail.py to="me@company.com" subject="SPLUNK alert" sendresults=true server=1.1.1.1

Even there are no results i receive message with text "No results".

Is it possible to exclude such messages?

Tags (2)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

You could change your search to a regular alert and remove the sendemail command from the search. Then you get features such as filtering for number of results > 0 through the alert configuration.

andrey2007
Contributor

Yes I had to choose this way and now i am modifying sendemail.py in search app.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Yup, those are hardcoded into the sendemail command. You can copy that python file and add your own command to splunk, say "mysendemail", and use that in alert_actions.conf. In there you can change how you'd like your mails to look.

0 Karma

andrey2007
Contributor

But i will get alert name, link to results and etc. even if i turn off pdf delivery and include inline results(

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Turn off PDF delivery then, you won't get an empty graph anymore.

0 Karma

andrey2007
Contributor

yes, it is pdf attachment. My main goal is to get only table without message headers(alert name, link to results and etc.)

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Is that delivered as a PDF attachment?

0 Karma

andrey2007
Contributor

something like result of chart command execution but it is empty and has legend with specified field names which I used in my search (user host source).

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

What do you mean by empty graph above it?

0 Karma

andrey2007
Contributor

Sure but when I make it i receive on email table with my results and empty graph above it. I do not know where does this graph originates from? So I tried sendemail command.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Mile High Learning with Splunk University, Denver, Colorado

If Denver is known for its mile-high elevation, Splunk University is about to raise the bar on technical ...

IT Service Intelligence 5.0 Series: Your Guide to the June Launch

We are excited to announce the June release of Splunk IT Service Intelligence (ITSI) 5.0. This update ...

Agent Mode Engaged! Enchaining Agentic Operations with Splunk AI Assistant 2.0

    Are you ready to transform how your team handles complex data requests? We invite you to our upcoming ...