How to determine if an alert triggered in SolarWinds platform

1/18/2020 5:04 PM

10/24/2025 9:53 PM

This servers as a guide on how to determine if an alert triggered by querying the AlertID of a specific alert and filtering the entries in AlertHistoryView using the AlertID.

Orion Platform

1. RDP to the SolarWinds Platform server.
2. Launch Database Manager from the SolarWinds Platform folder of the Start menu.
3. Click Add Orion Server.
4. Expand the SQL instance and SolarWinds database in bold.  Locate the AlertConfigurations table.
5. Right-click the table and select Query table.
6. Locate the alert via the Name column then determine its corresponding AlertID.
7. Query the AlertHistoryView(View) and filter the results using the AlertID.
Sample:

-- 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
where AlertID = 'xx'

(where xx is the AlertID)

8. Using the TimeStamp as a reference, determine if the alert was triggered.