Anyone else having published reports to fail when you include a variable such as MaxOutBpsTime or MaxInBpsTime ?
SELECT
Nodes.Caption AS NodeName, Interfaces.InterfaceTypeName AS Interface_Type_Name, Interfaces.Outbps AS Xmit_bps, Interfaces.OutPercentUtil AS Xmit_Percent_Utilization, Interfaces.OutPps AS XmitPps, Interfaces.OutPktSize AS XmitPktSize, Interfaces.OutUcastPps AS XmitUCastPps, Interfaces.OutMcastPps AS XmitMcastPps, Interfaces.MaxOutBpsToday AS MaxOutBpsToday, Interfaces.MaxOutBpsTime AS MaxOutBpsTime, Interfaces.StatusLED AS Status_Icon, Interfaces.Inbps AS Recv_bps, Interfaces.InPercentUtil AS Recv_Percent_Utilization, Interfaces.InPps AS RecvPps, Interfaces.InPktSize AS RecvPktSize, Interfaces.InUcastPps AS RecvUcastPps, Interfaces.InMcastPps AS RecvMcastPps, Interfaces.MaxInBpsToday AS MaxInBpsToday, Interfaces.MaxInBpsTime AS MaxInBpsTime, NullIf(InBps,-2)+NullIf(OutBps,-2) AS XmitRecvBps, (NullIf(InPercentUtil,-2)+NullIf(OutPercentUtil,-2))/2 AS AvgXmitRecvPercentUtil, Interfaces.NodeID AS NodeID, Interfaces.InterfaceID AS InterfaceID
FROM
Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)
WHERE
(
(Nodes.Department LIKE 'Dev%') AND
(Nodes.MachineType LIKE 'windows%') AND
(
NOT (Nodes.Caption LIKE 'lab%'))
)
ORDER BY 1 ASC
