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)