Hi Everyone,
Please I like to find out how the DateTime variable does its calculation of dates in such a way that it returns a value as the one highlighted (in blue) in the code below.
The Relative Time Frame in the Orion Report Writer was set to "Show data over the past 14 hours" and the todays date is February 03, 2014.
SELECT TOP 10000 Nodes.Caption AS NodeName,
Interfaces.Caption AS Interface_Caption,
AVG(InterfaceAvailability.Availability) AS AVERAGE_of_Availability,
Nodes.Location AS Location
FROM
(Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)) INNER JOIN InterfaceAvailability ON (Interfaces.InterfaceID = InterfaceAvailability.InterfaceID AND Nodes.NodeID = InterfaceAvailability.NodeID)
WHERE
( DateTime BETWEEN 41671.1732407407 AND 41671.7916666667 )
AND
(
(Interfaces.Caption LIKE '%Tunnel%%')
)
GROUP BY Nodes.Caption, Interfaces.Caption, Nodes.Location
ORDER BY 1 ASC