MySQL Bugs: #57573: Email message improvements

Bug #57573	Email message improvements
Submitted:	19 Oct 2010 15:35	Modified:	12 Nov 2010 23:03
Reporter:	Roger David Nay	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Advisors/Rules	Severity:	S4 (Feature request)
Version:	2.2.0.1709	OS:	Any
Assigned to:	Mark Leith	CPU Architecture:	Any

Description:
Change the text to UPPERCASE. Replace Success, with RECOVERED (or similar), as if you send a message to indicate that the problem has gone away then RECOVERED is more appropriate. The UPPERCASE issue is that it's easy to miss the "alarm level" in all the noise of the text in the body of the message.

Currently the output shows the email body in the order:

Problem Description
Advice
Recommended Action
Links and Further Reading
Thresholds
Frequency
Expression
Evaluated Expression

(a) if the message type is "Success" (or RECOVERED) then Advice/Action/... are rather unnecessary. you simply want to know which problem has gone away. The details you knew about from a previous message.

(b) if you get a lot of messages then the interesting thing in the message are the thresholds, expression and evaluated expression. On my mail reader ALL of these values are not visible when first opening the mail, and I must scroll down to see them. They are also the values which I am most interested in as after all the text. I would suggest here that most of the text is possibly better referenced on the web page provided by merlin, and not included in the email body itself. That is provide a brief description, but corrective action and further comments should be provided via a link on the merlin server. this will reduce the amount of text in the message. Also put the "values" and thresholds towards the top of the message where they will be visible without scrolling:

Something like:

Server: myserver-08
Time: 2010-10-19 10:54:08 CEST (2010-10-19 08:54:08 UTC)
Advisor: Administration - Attempted Connections To The Server Have Failed
Event: Attempted Connections To The Server Have Failed (myserver-08)
Frequency : 00:05:00

Thresholds: Critical: 50, Warning: 10, Info: 1

Expression: %Aborted_connects% > THRESHOLD
Evaluation: 0 > 1

How to repeat:
N/A

Suggested fix:
Make the necessary changes or add options to enable this functionality.

Note: 'Success' could also be 'OK' if 'RECOVERED' is not deemed suitable.

Mark Leith writes: 
Patch pushed to 2.3:

8232 Mark Leith	2010-10-25
     EM-4984	- Email message improvements
     - test fixes
...
8231 Mark Leith	2010-10-25
     EM-4984 - Email message improvements
     - Make the severity upper case in the subject
     - Move order to Frequency, Thresholds, Expression, Evaluated Expression, Problem Description, Advice, Recommended Action, Links and Further Reading