I have created below sql report to show Alert report with Acknowledge details for previous day. but its not showing correct data, can someone check and help me.
Select o.AlertObjectID As Ticket_Number,o.AlertID,o.EntityCaption as Object, o.RelatedNodeCaption as NodeName, N.IP_Address, o.RelatedNodeID as NodeID,
dateadd(HH,-4,a.TriggeredDateTime) as FirstAlertTime, dateadd(HH,-4,o.LastTriggeredDateTime) as LastAlertTime, a.TriggeredMessage, o.EntityType, o.AlertNote, a.AcknowledgedBy,dateadd(HH,-4,a.AcknowledgedDateTime) as AckTime
From AlertObjects O
INNER JOIN AlertActive A on (o.AlertObjectID = a.AlertObjectID)
INNER JOIN Nodes N on (o.RelatedNodeID = N.NodeID)
WHERE
LastTriggeredDateTime > (dateadd(day,datediff(day,0,getdate()),0))
LastTriggeredDateTime > DATEADD(d,-1,GETDATE())
order by o.LastTriggeredDateTime asc