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
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
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
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.