Component Monitor info when unknown/down.

I have a component monitor that went unknown/down. When it did the info button was under the status column. I hovered over it and started to read the info, just then the page refreshed, and component changed status to up, and info button is gone. Is there anyway to get that info after the fact? I can't seem to find it anywhere.

Find more posts tagged with

Accepted answers

Petr.Vilem

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.

All comments

bobross

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.

DaveAz

Could something be put in the Alert Trigger to pull that and send it in the alert email? I'ma go looking. Thanks!