Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

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: 198 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

Tags

Classifications

Public