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
Thanks people for your assistance in this matter.
--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
mesverrum, when I execute the query you've suggested inside the Database manager, it throws error:
Msg 208, Level 16, State 1, Line 2
Invalid object name 'orion.actionsassignments'.
Thanks people for your assistance in this matter.
--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
mesverrum, when I execute the query you've suggested inside the Database manager, it throws error:
Msg 208, Level 16, State 1, Line 2
Invalid object name 'orion.actionsassignments'.
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.