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) > 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
16:51, 22 May 2017

Tags

Classifications

Public