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 > Network Performance Monitor (NPM) > SQL report received for Last 24 Hours Email Alerts

SQL report received for Last 24 Hours Email Alerts

Created by Perry Ginno Casio, last modified by Rodim Suarez on Mar 29, 2017

Views: 22 Votes: 1 Revisions: 5

Overview

A custom report for Last 24 Hrs Email Alerts was received.

 

Environment

NPM 11.5.2

Resolution

  1. Click Start > All Programs > SolarWinds Orion > Alerting, Reporting, and Mapping > Report Writer.
  2. Create an SQL report in Report Writer using the following SQL query:
    SELECT ALERTHISTORY.MESSAGE AS AlertAction, ACTIONS.TITLE as AlertActionTitle, ALERTHISTORY.TIMESTAMP AS TriggeredTime, ACTIONS.ACTIONTYPEID as AlertMethod FROM ALERTHISTORY
    INNER JOIN ACTIONS ON ALERTHISTORY.ACTIONID = ACTIONS.ACTIONID
    WHERE ALERTHISTORY.TIMESTAMP >= dateadd(day,datediff(day,1,GETDATE()),0) AND ACTIONS.ACTIONTYPEID = 'Email'
Last modified
02:51, 29 Mar 2017

Tags

Classifications

Public