topic Re: Remove query and table header from Emails in Alerting

Remove query and table header from Emails

Andruep — Sat, 30 Oct 2010 04:05:14 GMT

Is there any way to remove the query and table header information from alerts? I am aware of a previous question on the topic however there has not been a solution since that posting. Basically some of my alerts will be sent to smartphones and I would like to remove as much content as possible and only provide meaningful fields.

Re: Remove query and table header from Emails

southeringtonp — Sat, 30 Oct 2010 04:41:35 GMT

See also this earlier thread. A couple of possibilities:

Run a scheduled search, but instead of using the normal alert mechanism, call the sendemail command directly, e.g., |sendemail to=user@domain.com subject="Something" sendresults=true

Roll your own version of the emailer script (see thread 6423 for more detail).

Re: Remove query and table header from Emails

Andruep — Wed, 03 Nov 2010 03:34:50 GMT

Thanks for the suggestion, however, I received the error below after adding the sendemail string to the end of my search.

[Errno 10061] No connection could be made because the target machine actively refused it while sending mail to: abc@abc.org.

abc@abc.org is a filler email address. My actual email address was used.

Re: Remove query and table header from Emails

southeringtonp — Thu, 04 Nov 2010 00:37:44 GMT

By default, it will use localhost as the mail server. If you want to use a remote server, you can add another parameter server=mail.yourdomain.com

Re: Remove query and table header from Emails

kknopp — Fri, 11 Oct 2013 14:56:52 GMT

If I were to do something like the above, can I still have it trigger only if there are results? I have started using CASE recently, but that doesn't seem like an appropriate method here...

Re: Remove query and table header from Emails

0range — Fri, 24 Jan 2014 07:55:40 GMT

Really, seems like direct sendemail command disables all the alerting conditions, isn't it?