How to view and list which alarm that sends out email from Solarwinds?

Question

People,

I need to know and generate the list of alert / alarm that sends out email for audit & standardization.

How to get the list of alarms and where the location in the Solarwinds page?

Thanks in advance

j_a_catlin · Accepted Answer

You can use the action manager or write a SQL/SWQL query and run it against the DB to get the information.  For the actions manager go to manage your alerts in the console and select the Actions Manager tab, or navigate to:

<your orion Url>/Orion/Actions/Default.aspx

Then you can group by action type for the action type that you want, likely Send an email/page and maybe email a web page.  It will give you a list of the assigned alerts that each action is on.  If it has more than one alert, it will list the number of alerts that the action is assigned to.  You can hover over that number to get the names of the alerts.

-j_a_catlin

Loop1 Systems: SolarWinds Training and Professional Services

* LinkedIN: Loop1 Systems
* Facebook: Loop1 Systems
* Twitter: @Loop1Systems

mesverrum · Accepted Answer

I use a custom SWQL query for getting the relevant info on alert actions, you could filter it a few ways to narrow in on things if you like.

--Alert Configuration and Actions Report
select
ac.name as [Alert Name]
,'/Orion/Alerts/Default.aspx' as [_linkfor_Alert Name]
,case when ac.Enabled=1 then '/Orion/images/StatusIcons/Small-Up.gif'
when ac.Enabled=1 then '/Orion/images/StatusIcons/Small-Up.gif'
end as [_iconfor_Alert Name]
,ac.Description
,ac.Frequency
,case when ac.frequency < 60 then '/Orion/images/StatusIcons/Small-Critical.gif'
else '/Orion/images/StatusIcons/Small-Up.gif'
end as [_iconfor_Frequency]
,CASE
WHEN ac.Severity = 2 then 'Critical'
WHEN ac.Severity = 3 then 'Serious'
WHEN ac.Severity = 1 then 'Warning'
WHEN ac.Severity = 0 then 'Informational'
WHEN ac.Severity = 5 then 'Notice'
END AS [Severity]
,CASE
WHEN ac.Severity = 2 THEN '/Orion/images/ActiveAlerts/Critical.png'
WHEN ac.Severity = 3 THEN '/Orion/images/ActiveAlerts/Serious.png'
WHEN ac.Severity = 1 THEN '/Orion/images/ActiveAlerts/Warning.png'
WHEN ac.Severity = 0 THEN '/Orion/images/ActiveAlerts/InformationalAlert.png'
WHEN ac.Severity = 5 THEN '/Orion/images/ActiveAlerts/Notice.png'
END AS [_iconfor_Severity]
,ac.AlertMessage
--,ac.trigger
--,ac.reset
,aa.CategoryType
,a.actiontypeid
,ap.propertyname
,ap.propertyvalue

from orion.actionsassignments aa
join orion.alertconfigurations ac on aa.parentid=ac.alertid
join orion.actions a on a.actionid=aa.actionid
join orion.actionsproperties ap on ap.actionid=a.actionid

where ac.enabled=1
and ap.PropertyName not in ('EscalationLevel','executionIfAknowledge','executionRepeatTimeSpan','MessageContentType','Priority','SmtpServerID' )
and ap.PropertyValue is not null and ap.PropertyValue not like ''
--and (propertyname like 'EmailTo' or propertyname like 'EmailCC' or propertyname like 'EmailBCC')
--and (ac.name like '%${SEARCH_STRING}%' or ap.propertyvalue like '%${SEARCH_STRING}%' )`

order by ac.Name, aa.Categorytype desc, a.ActionTypeID, ap.PropertyName

bobmarley · Accepted Answer

https://support.solarwinds.com/SuccessCenter/s/article/SQL-Query-to-trace-which-actions-are-assigned-to-an-alert

Here is another one