5 Replies Latest reply on Nov 11, 2011 9:00 AM by mavturner

    Top XX Nodes by Percent Ports Used: Divide by Zero error encountered


      The resource window displays the error:

      The "Top 10 Nodes by Percent Ports Used" resource threw an exception..
      SWIS query error. SWQL Query: SELECT TOP 10 S.NodeID, N.Status, N.Caption, N.IP_Address, S.LastScan, S.LastSuccessfulScan, S.LastScanResult, S.PortCount, S.ActivePortCount, (S.PortCount-S.ActivePortCount) as [PortsAvailable], ((S.ActivePortCount * 100 ) / (S.PortCount )) as [PortPercentUsed] FROM Orion.Nodes N INNER JOIN Orion.UDT.Switch S ON N.NodeID=S.NodeID WHERE S.ActivePortCount>0 Order By [PortPercentUsed] DESC, [PortsAvailable] ASC, S.ActivePortCount DESC SWIS Error: Divide by zero error encountered.
      Unclear what causes this error. Somebody any ideas?