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 > Server & Application Monitor (SAM) > Find the alert history in Orion

Find the alert history in Orion

Table of contents

Updated May 31, 2017

Overview

This article provides steps on how to find the alert history in Orion Platform products and the name of the alert that corresponds to that history.

Environment

All Orion Platform products

Steps

 

  1. On the Orion Platform server, click Start > Programs > SolarWinds Orion > Advanced Features > Database Manager.
  2. Click Add Default Server, and then click Expand (+)  on the SolarWindsOrion database (database name may vary).
  3. Double-click any table.
  4. Execute the following in the Query window:
    The timestamp is in UTC and not in local time.
    SELECT * FROM AlertHistoryView order by timestamp desc
  5. The alert history should appear in the Results window.
  6. The AlertID on each row points to the name of the alert in the AlertConfigurations table. Execute the following query:
SELECT Name FROM AlertConfigurations WHERE AlertID = <AlertID from query above>

 

Last modified

Tags

Classifications

Public