Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Server & Application Monitor (SAM) > SQL Query to trace which actions are assigned to an alert

SQL Query to trace which actions are assigned to an alert

Table of contents
Created by Norsolihati Selamat, last modified by An Kian Wong on May 18, 2017

Views: 139 Votes: 0 Revisions: 8

Overview

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

Environment

NPM 11.5.x and later

Detail

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.

 

 

Last modified
01:26, 18 May 2017

Tags

Classifications

Public