I've been wondering about this myself. Doing some database diving I found the following:
dbo.APM_CurrentComponentStatus has an ErrorMessage field that coincides with what is shown in the info box, but it changes as the component status changes.
Unfortunately, I haven't been able to find anywhere in the database where the Message data (what is shown in the info box) is stored historically.
dbo.APM_ComponentStatus_Detail seemed the most promising, but that data isn't there.
Could something be put in the Alert Trigger to pull that and send it in the alert email? I'ma go looking. Thanks!
Historical error messages are still stored in database, you can find them using this query:
SELECT csd.ApplicationID, csd.ComponentID, csd.TimeStamp, ISNULL(e1.ErrorMessage,ISNULL(e2.ErrorMessage, e3.ErrorMessage)) msg FROM APM_ComponentStatus_Detail csd
LEFT JOIN APM_ProcessEvidence e1 on csd.ID = e1.ComponentStatusID
LEFT JOIN APM_PortEvidence e2 on csd.ID = e2.ComponentStatusID
LEFT JOIN APM_DynamicEvidence e3 on csd.ID = e3.ComponentStatusID
To narrow it down only to statuses which usually have not null message add where clause:
WHERE csd.Availability NOT IN (1,5,8)
To show historical messages only for specific component add where clause:
WHERE csd.ComponentID = XXX, where XXX is component id which can be found when you hover component somewhere in UI and see link ...?NetObject=AM:XXX
...or combine both these filters.
For the alerts, there should be macro ${StatusOrErrorDescription} which contains current message.
