WHERE
( EventTime BETWEEN 40223 AND 40254 )
AND
(
(Nodes.Department = 'Airport Operational Systems') OR
(Nodes.Department = 'Telecommunications') OR
(Nodes.Department = 'Corporate Systems') OR
(Nodes.Department = 'Network Operations') OR
(Events.Message LIKE '%%has stopped responding%%') OR
(Nodes.Escalation_Severity LIKE '%%Non-Critical%%') OR
(Events.EventTime BETWEEN '2010-01-03 17:00:00' AND '2010-02-03 07:00:00')
)
Can anyone tell me why this isn't working?
When I perform this query I get I HUGE range of dates.
I have tried the 2010-01-03 in the 2010-03-01 syntax as well and get the same results.
What I am trying to accomplish is I want to know about Non-Critical Nodes that go down between the hours of 17:00 and 07:00. I don't know if I am trying to get this information from the wrong spot or what.