Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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: 38 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