Submit a ticketCall us
Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Exclude A Specific Alert from the Report "Alerts Triggered in the Last 24 Hours"

Exclude A Specific Alert from the Report "Alerts Triggered in the Last 24 Hours"

Table of contents

Updated October 9, 2017

Overview

This article discusses how a user can exclude a specific alert from the report "Alerts Triggered in the Last 24 Hours".

 

At present, it is not possible to select the parameter "EventID" or AlertID" in order to exclude a specific Alert from the report using the GUI. However, you can workaround this by using an SQL Query as detailed in the steps below.

 

Environment

  • NPM 12.0+
  • SAM 6.2.4+ 

Steps

As a workaround, this can be done by using a SQL Query such as Query 1 detailed here. 

 

Query 1:

SELECT * FROM [dbo].[AlertHistoryView]
Where EventTypeWord like '%Triggered%' And AlertID <> 148 
And Timestamp >= DATEADD(day, -1, GETDATE())

 

The above pulls all Triggered Alerts from the AlertHistoryView for the past 24 hours but excludes the AlertID 148 as an example. 

 

 

In order to get the AlertID related to the alert that you want to exclude, simply log into the Solarwinds Server:

- Open database manager

- Click Add Default Server

- Right click the Solarwinds Database > Select New Query

- Paste the contents of Query 2: 

 

Query 2:

SELECT AlertID, Name FROM [dbo].[AlertConfigurations]
Where name like '%Node is down%'

 

* Please change "Node is down" of Query 2 to the name of the alert which you want to exclude from your report : e.g. '%YourAlert%' *

-  Note the AlertID in the first column, and input this number into Query 1 above in place of 148. 

 

 

To create the custom SQL report

- Log into the Orion Web Console

- Settings > Manage Reports

- Create new report

- Select Custom Table

- Change the drop down for Selection Method to Advanced Database Query (SQL, SWQL)

- Select SQL from the radio buttons

- Paste the contents of Query 1 above into the box & click add to layout

- Add the relevant columns which you would like displayed in the report and save changes

 

-------------------------------------

Please note, any custom scripts or other content posted herein are provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software that you have purchased from SolarWinds, and the information set forth herein may come from third party customers. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. Any custom scripts obtained herein are provided to you “AS IS” without indemnification, support, or warranty of any kind, express or implied. You elect to utilize the custom scripts at your own risk, and you will be solely responsible for the incorporation of the same if any.

-------------------------------------

 

 

Last modified

Tags

Classifications

Public