I noticed a spike in our alerts and wanted to come up with a query that would help identify what Alert was causing the spike. Here is a simple SQL query that with a customization of the date you'll be able to see a breakdown of alerts by alert name sorted by their trigger count
SELECT DISTINCT([Name]), COUNT(AlertID) AS [Alert Count]
FROM [SolarWindsOrion].[dbo].[AlertHistoryView]
Where TimeStamp >= 'yyyy-mm-dd' AND TimeStamp < 'yyyy-mm-dd'
Group BY Name
Order BY [Alert Count] DESC
The Date portion should be yyyy-mm-dd
You can then take the results to the following query
SELECT DISTINCT(RelatedNodeCaption), EntityCaption
FROM [SolarWindsOrion].[dbo].[AlertHistoryView]
Where TimeStamp >= 'yyyy-mm-dd' AND TimeStamp < 'yyyy-mm-dd' AND Name = 'Alert Name'
Where 'Alert Name' is the name of the alert you'd like to see detail on.