Bug #47895 notifications: email format, alerter level notification to different group
Submitted: 7 Oct 2009 11:57
Reporter: Bogdan Kecman Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Monitor: Server Severity:S4 (Feature request)
Version:2.0.x, 2.1.x OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[7 Oct 2009 11:57] Bogdan Kecman
Description:
Getting the MEM notification to send SMS for example is terribly difficult even with simple email2sms systems. They all require different setup's, for e.g. some need "setup" in the Subject: line (for e.g. pass=mypass,from=alert,flash=n) and the content in the body (usually with some string like 'END' appended to the end of the message), some require message to be in Subject line and parameters in body, some require body to start with parameters and message to follow etc etc etc... the SMS coding MEM can format emails are is easily parsed but requires that you send email to your local address where you pipe it to application that will process it.

It would be good if user can influence how the email for a specific notification list will look like (per notification list).

The other issue is, attm, if you want to have DBA on call informed on the info and "all dba's" on "warning" and "manager too" on "crytical" alert, you have to copy rule 3 times and set different notification list for each rule. It would be great if notification list can have flag's "accept info, accept warning, accept crytical", or even - each user in single notification list.

How to repeat:
try to send sms from merlin

Suggested fix:
Allow user to make a template for each notification list with variables for both subject and body fields. Something like

Subject: pass=mypass,flash=n,from=ALERT

Body: %SERVERNAME% %SEVERITY% problem on %ADVISORNAME%. Thr val is %THRESHOLD% 

or

Subject: %SERVERNAME% %SEVERITY% problem on %ADVISORNAME%. Thr val is %THRESHOLD% 
Body :
pass=mypass
flash=n
from=ALERT

With regards to severity, it would be great if each email in notification list can have flag's what severity issues he receives (info/warning/severe)
[17 Dec 2014 7:05] Daniƫl van Eeden
This could be a duplicate of Bug #40728

In MEM 3.0 there is a specific setting for SMS:
"<checkbox>: SMS (use SMS encoding for this notification group)"