quote:

---

"a report that shows trending on packet loss or the number of times packet loss has occurred may be useful showing a troublesome circuit that has issues popping up from time to time"

---

SELECT 
    N1.Caption as NodeName,
    SUM(CASE 
          WHEN R1.PercentLoss > 0 
          THEN 1 
          ELSE 0 
          END) as Greater_Than_0,
    SUM(CASE 
          WHEN R1.PercentLoss > 50 
          THEN 1 
          ELSE 0 
          END) as Greater_Than_50
FROM Nodes N1 
INNER JOIN ResponseTime R1
ON N1.NodeID = R1.NodeID
GROUP BY N1.Caption
ORDER BY N1.Caption

NodeName          Greater_Than_0      Greater_Than_50
Node1             10                  5
Node2             20                  0
etc...

SELECT t.NodeName,
       COUNT(*) as Occs
FROM
(
SELECT 
       YEAR([DateTime]) as Y,
       MONTH([DateTime]) as M,
       N1.Caption as NodeName,
       MAX(R1.PercentLoss) AS Max_Packet_Loss
FROM Nodes N1 
INNER JOIN ResponseTime R1
ON N1.NodeID = R1.NodeID
GROUP BY YEAR([DateTime]) ,
         MONTH([DateTime]),
         N1.Caption
 HAVING MAX(R1.PercentLoss)>50
 ) t
GROUP BY t.NodeName