nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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
Store

Alert SQL Report Question: How does alert definition join with an alert action message?

gbutler

I created a report that contains Alert Name, trigger query, suppression definition, and target.

I'd like to include the AlertAction.TriggerMessage, but I don't see how they relate? (i.e. how do I join the trigger message with it's Alert).

Here is what I have:

SELECT

AlertDefinitions.AlertName AS Alert_Name,
AlertDefinitions.TriggerQuery AS Trigger_Query,
AlertDefinitions.SuppressionQuery AS SuppressionQuery,
ActionDefinitions.Target AS To_Addr

FROM AlertDefinitions

INNER JOIN ActionDefinitions ON AlertDefinitions.AlertDefID = ActionDefinitions.AlertDefID

Where

AlertDefinitions.Enabled='True' AND ActionDefinitions.ActionType = 'EMail'

ORDER BY 1 ASC

Find more posts tagged with

Accepted answers

scottd

I think the AlertActions table is for basic alerts, and the other tables mentioned are for advanced alerts. I believe you can get the message you are after by adding this to the select portion of the statement;

ActionDefinitions.Parameter2 AS Message

Is this the message you are looking for?

All comments

scottd

ActionDefinitions.Parameter2 AS Message

Is this the message you are looking for?

gbutler

Yep. That is what I want.

I "knew" the message field had to be somewhere but did not see it.

Thanks!

FormerMember

Hello gbutler-

Thank you for this query. I am having an interesting issue with it, however. When I view it on the Reports webpage, it is duplicating every entry. Have you ever seen this?

Thanks,

Mike

gbutler

Mike:

I've been away from reports in Solarwinds for about a year. That said, I have not seen what you are experiencing. Only idea i have for you is to get the underlying SQL and see if the behavior can be seen in the straight SQL. If you do not know SQL, there is usually someone in Thwack that will help.

glenn.