Submit a ticketCall us
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


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


All Orion Platform products



  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