I am designing a report using Report Designer. I am not a sql guru and would like to modify my report to display 2 more columns
Below is the report and I would like to add Port and Protocol fields to my report. Can someone help please?
SELECT TOP 10000 Nodes.DNS AS DNS,
Nodes.NodeID AS NodeID,
Nodes.IP_Address AS IP_Address,
Case
When InBandwidth+OutBandwidth=0 Then 0
When InBandwidth=0 Then
(Out_Averagebps/OutBandwidth) * 100
When OutBandwidth=0 Then
(In_Averagebps/InBandwidth) * 100
Else
( (Out_AverageBps/OutBandwidth)+(In_AverageBps/InBandwidth))*50
End AS CircuitUtil_AvgRecvXmit,
Interfaces.MaxOutBpsToday AS MaxOutBpsToday,
InterfaceTraffic.DateTime AS DateTime,
Interfaces.InterfaceID AS InterfaceID
FROM
(Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)) INNER JOIN InterfaceTraffic ON (Interfaces.InterfaceID = InterfaceTraffic.InterfaceID AND InterfaceTraffic.NodeID = Nodes.NodeID)
WHERE
( DateTime BETWEEN 40333.6659027778 AND 40335.6666666667 )
AND
(
(Nodes.DNS = 'xxxx.xxx.com') AND
(Nodes.IP_Address = '10.20.100.10') AND
((NullIf(InPercentUtil,-2)+NullIf(OutPercentUtil,-2))/2 > 0) AND
(Nodes.NodeID = 167) AND
(InterfaceTraffic.DateTime > '2001-01-01')
)
ORDER BY 3 ASC, 4 ASC, 5 ASC, 6 ASC
