I have a report the list events for the past 24 hours. I now need that same report for just yesterday.
, ToLocal(e.EventTime) as EventTime
FROM Orion.Events AS e
INNER JOIN Orion.EventTypes AS et ON et.EventType = e.EventType AND et.InstanceSiteId = e.InstanceSiteId
WHERE e.message LIKE 'ORION ALERT:%'
and e.EventTime > AddDate('day', -1, GETDATE())
ORDER BY e.EventTime DESC
This returns the " Event ORION ALERTS:" for the past 24 hours.
I want the events for yesterday
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.