Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Orion Platform > 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