Submit a ticketCall us

AnnouncementsTHWACKcamp 2018 is here

2018 is the seventh year for THWACKcamp™, and once again we’ll be live October 17 – 18 with packed session tracks covering everything from network monitoring and management, to change control, application management, storage, cloud and DevOps, security, automation, virtualization, mapping, logging, and more.

Register for online sessions.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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_ret on Mar 29, 2017

Views: 301 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