Report Help: # of times a wan link hits 90%

lateforwork2

Looking to get a little bit of help because I'm stumped.

I need to have the DNS name and the number of times it has hit 90 percent transmit, receive (or a combo of both).  I'm having issues using Count.

Any help is greatly appreciated!

njoylif

try extrapolating from this or just try adding count(*) to the bottom of your query to get the #:

Nodes.NodeID,

Nodes.Caption,

Interfaces.InterfaceID,

Interfaces.Caption,

Interfaces.OutBandwidth,

Interfaces.InBandwidth,

COUNT(*)

FROM

(InterfaceTraffic_Detail INNER JOIN Interfaces ON (Interfaces.InterfaceID = InterfaceTraffic_Detail.InterfaceID) )

INNER JOIN Nodes ON (Nodes.NodeID = Interfaces.NodeID)

WHERE

(Nodes.Caption LIKE 'R-XRT-%') AND (Nodes.ServiceFTP <> 1) AND

(   (InterfaceName LIKE 'Ser%.%') AND (InterfaceName NOT LIKE 'Ser%.16')  )     AND

(

    (((InterfaceTraffic_Detail.In_Averagebps/Interfaces.InBandwidth)*100) > 45)

         OR

    (((InterfaceTraffic_Detail.Out_Averagebps/Interfaces.OutBandwidth)*100) > 45)

)

GROUP BY

Nodes.Caption, Nodes.NodeID, Interfaces.InterfaceID, Interfaces.OutBandwidth,

Interfaces.InBandwidth, Interfaces.Caption

ORDER BY Nodes.Caption