Hi,
I have built a report that lists the number of times a node dropped in the last 7 days. I would like to add the availability for that time period as well.
Here is my SQL
---
SELECT TOP 10
Nodes.StatusLED AS Status_Icon,
Nodes.NodeID AS NodeID,
Nodes.Caption AS NodeName,
Nodes.Priority AS Priority,
COUNT(Events.EventType) AS COUNT_of_Event_Type,
Nodes.Caseref AS Caseref,
Nodes.Client_Friendly_Name AS Client_Friendly_Name
FROM
Nodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)
WHERE
( EventTime BETWEEN 40616 AND 40623 )
AND
(
(Events.EventType = 1) AND
)
GROUP BY Nodes.StatusLED, Nodes.NodeID, Nodes.Caption, Nodes.Priority, Nodes.Caseref, Nodes.Client_Friendly_Name
ORDER BY 4 ASC, 5 DESC
---
Is anyone able to point me in the right direction?
Thanks
Tom
