Hello Team,
creating a modern dashboard in which department want to see particular Alert no. generated for last 24 hours, with help of SQWL we had created below query but its giving wrong no. as it show alert triggered + reset value while we are looking only for no. of alert triggered.
SWQL Query :
SELECT Count (a.AlertActiveID) as value FROM Orion.AlertHistory a
inner join Orion.AlertObjects b on a.AlertObjectID = b.AlertObjectID
where b.AlertID = 597 and a.TimeStamp >= ADDHOUR(-24,GETDATE())
SQL Query
SELECT Count(AlertID) FROM [dbo].[AlertHistoryView] where alertid=597 and timestamp > dateadd(hh, -24, getdate()) and eventtypeword = 'Triggered'
==
anyone can help me to get exact count.
