Find the alert history in the SolarWinds Platform

11/29/2018 10:30 PM

6/9/2025 9:22 PM

This article provides steps on how to find the alert history in the SolarWinds 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 that 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:
Polling Settings

Server Application Monitor

1. On the SolarWinds Platform server, click Start > Programs > SolarWinds Platform > Database Manager.
2. Click Add Orion 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.

-- Scripts are not supported under any SolarWinds support program or service. 
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further 
-- disclaims all warranties including, without limitation, any implied warranties 
-- of merchantability or of fitness for a particular purpose. The risk arising 
-- out of the use or performance of the scripts and documentation stays with you. 
-- In no event shall SolarWinds or anyone else involved in the creation, 
-- production, or delivery of the scripts be liable for any damages whatsoever 
-- (including, without limitation, damages for loss of business profits, business 
-- interruption, loss of business information, or other pecuniary loss) arising 
-- out of the use of or inability to use the scripts or documentation

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:

-- Scripts are not supported under any SolarWinds support program or service. 
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further 
-- disclaims all warranties including, without limitation, any implied warranties 
-- of merchantability or of fitness for a particular purpose. The risk arising 
-- out of the use or performance of the scripts and documentation stays with you. 
-- In no event shall SolarWinds or anyone else involved in the creation, 
-- production, or delivery of the scripts be liable for any damages whatsoever 
-- (including, without limitation, damages for loss of business profits, business 
-- interruption, loss of business information, or other pecuniary loss) arising 
-- out of the use of or inability to use the scripts or documentation

SELECT Name FROM AlertConfigurations WHERE AlertID = <AlertID from query above>

7. Select the AlertHistoryView table from the default server.
8 Right-click the table and click on the query table>execute the query.
9. The alert history should appear in the Results window.