Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > Show acknowledged alerts and notes in a report

Show acknowledged alerts and notes in a report

Table of contents

Updated May 22, 2017

Overview

This article describes how to create a report on acknowledged alerts showing the acknowledgment notes, which can be used to review historical alerts that have been addressed and the actions used to address them.

 

When Orion generates an alert, it is displayed under Active Alerts as long as the trigger condition is active. When the alert has been resolved and the user has added acknowledgment and resolution notes, the trigger condition is no longer active and the alert is removed from the list of active alerts. 

Environment

NPM 11.5 and later

Steps

The AlertHistoryView table shows the history of the alert including those that have been acknowledged and the notes placed during the acknowledgment. Execute the following query using Orion Database Manager:

Select
       TimeStamp, 
       EventTypeWord, 
       Name, 
       ObjectType, 
       Message, 
       AccountID, 
       AlertObjectid, 
       EntityCaption, 
       LastTriggeredDateTime, 
       AlertNote, 
       Severity
FROM [dbo].[AlertHistoryView]
WHERE EventTypeWord = 'acknowledged'
Order by TimeStamp DESC

This query can also be used to generate a report by using the Advanced SQL template when creating the report, and then apply this query.

 

The following is a sample output of the query when executed in Orion Database Manager. The Message Column shows the details entered during alert acknowledgment:

 

 

Last modified

Tags

Classifications

Public