Network Management

SQL Query to trace which actions are assigned to an alert

This article provides steps to query which particular email addresses are assigned to which alert using SQL query.

First published date

10/9/2018 6:47 PM

Last published date

10/15/2018 2:01 PM

Overview

This article provides steps to query which particular email addresses are assigned to which alert using SQL query.

Product section

Network Performance Monitor

Resolution

Run the following SQL query against the Database:

SELECT ac.AlertID, ac.Name, ac.Description, ac.Enabled, 
ac.Severity, ac.CreatedBy, ap.ActionID,a.actiontypeid, ac.AlertMessage,
a.Title, a.Description, ap.PropertyName, ap.PropertyValue
FROM ActionsProperties ap
LEFT JOIN ActionsAssignments aa ON ap.ActionID = aa.ActionID
LEFT JOIN Actions a ON a.ActionID = ap.ActionID
LEFT JOIN AlertConfigurations ac ON aa.ParentID = ac.AlertID
WHERE ac.Enabled='true' and a.actiontypeid = 'email' and a.Description like 
 '%test@test.com%'

You need to change '%test@test.com%' to the email address that you are looking for.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.