Does anyone have a SQL Query that returns the nodes that alerted most over the past 30 days?

leonejames1

Does anyone have a SQL Query that returns the nodes that alerted most over the past 30 days? I would like to run a query that shows whcih nodes triggered the most alerts over the past 30 days.

Thank you!

leonejames1

Thank you all.... I actually ended up creating a query that worked. Thank you for the lead

SELECT TOP 300
    RelatedNodeID AS NodeID,
    RelatedNodeCaption AS NodeName,
    MAX(TimeStamp) AS LastTriggeredDateTime,
    COUNT(*) AS Triggered,
    Message AS AlertAction,
    Name AS AlertType
FROM
    AlertHistoryView
WHERE
    TimeStamp >= DATEADD(day, -30, GETDATE()) -- Selecting data from the last 30 days
GROUP BY
    RelatedNodeID,
    RelatedNodeCaption,
    Message,
    Name
ORDER BY
    Triggered DESC, -- Order by TriggerCount in descending order
    LastTriggeredDateTime DESC; -- Then order by LastTriggeredDateTime in descending order