Wrote a query to trigger the alert only during the specified time
Query getting failed on the timestamp,
On removing the time stamp, query is getting accepted. Below is the query, kindly suggest
SELECT Nodes.Caption, Nodes.NodeID FROM Nodes
Join AlertLog on Nodes.NodeID = AlertLog.ObjectID
Where (City = 'London' and TimeStamp < '10:00:00' and TIMESTAMP >'11:00:00')