Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Component status in Application alert email

I am hoping someone can lend me a hand. I have several SAM application monitors that are comprised of 4-6 component monitors. Right now, the alert has to look at the component health in order to give the exact reason ("${StatusOrErrorDescription}" variable) it triggered a Down state. This means that I get 4-6 individual emails when an entire application goes down.

What I want it to do is to trigger when the application status goes to Down, but the e-mail to contain the name, status AND error message of the component alert. The the trigger condition is set to "APM: Application", there is an option to include the "${ComponentswithStatusFormatted} variable. This is great! It lists all the assigned components and their status. However, I cannot get the error message to appear.

How can I use the "${StatusOrErrorDescription}" variable in an "APM: Application" -based alert?

Find more posts tagged with

apm_monitoring_template

Accepted answers

All comments

aLTeReGo

Currently the ${StatusOrErrorDescription} macro is limited to component monitors. Below is a listing of similar macros that can be used for Applications, though I don't believe they will provide you with exactly the same information. This sounds like a good idea to post in the SAM Ideas section of Thwack.

${ComponentsWithProblems}

${ComponentsWithProblemsFormatted}

${ComponentsWithProblemsFormattedHtml}

${ComponentsWithStatus}

${ComponentsWithStatusFormatted}

${ComponentsWithStatusFormattedHtml}

Detroiter

Those macro DO work, but do not go quite far enough. I need to include why a component is in a Down state as well. Are those macro based on SQL queries? If so, would it be possible to modify it into a new SELECT query that i can use now?

aLTeReGo

Theoretically you should be able to using ${SQL:SELECT'} to build your own custom SQL query, but this would be a fairly complicated query requiring several inner joins to work properly. This is a something probably better suited for the Alerts Lab.

Petr.Vilem

Values for these macros are cached in separate table (APM_ApplicationAlertVariable) and updated from polling. It cannot be selected on demand from alerts for performance reasons.

Detroiter

Yes, Petr, I can see that data in the dbo.APM_ApplicationAlertVariable table. How is that data getting populated within the macro? It would seem to me that rather than having several columns devoted to just Status, one should capture the ErrorMessage column of component status.

Is that macro something I can edit manually? For example replacing the ComponentsWithStatus column for ComponentsWithErrorMessage? If so, where is it located?