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 > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > 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.

 

Note: The Alert History is based upon the value you have provided for 'Events' retention under 'Polling Settings'.

ie. If you are only storing Events for 30 days it will only be possible to generate reports back as far as this date.

 

Note: We do not delete historical Alert data for currently active Alerts. For example if you have an Alert which is currently still triggered & is greater than the value of the Events retention settings this will still be present in the AlertHistoryView table. Once the alert is resolved and nighty database maintenance is run the AlertHistory will be summarized as normal.

 

For more information on Database Retention settings or how these can be tweaked be please see the following:
Default database retention settings

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