Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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