SolarWinds uses cookies on our websites to facilitate and improve your online experience. By continuing to use our website, you consent to our use of cookies. For further details on cookies, please see our cookies policy.
Hide this message
A custom report for Last 24 Hrs Email Alerts was received.
NPM 11.5.2
SELECT ALERTHISTORY.MESSAGE AS AlertAction, ACTIONS.TITLE as AlertActionTitle, ALERTHISTORY.TIMESTAMP AS TriggeredTime, ACTIONS.ACTIONTYPEID as AlertMethod FROM ALERTHISTORY
INNER JOIN ACTIONS ON ALERTHISTORY.ACTIONID = ACTIONS.ACTIONID
WHERE ALERTHISTORY.TIMESTAMP >= dateadd(day,datediff(day,1,GETDATE()),0) AND ACTIONS.ACTIONTYPEID = 'Email'