8 Replies Latest reply on Jan 20, 2014 4:40 PM by rgward

    UDT Report - List all used and unused gigabit ports

    Deltona

      Hi!

       

      I need a report that lists all used and unused gigabit and 10 gig ports in UDT, per node.

      The following could maybe be used in conjunction with the UDT usage report.

       

      SELECT 
      Interfaces.Caption AS Interface_Caption, Interfaces.InterfaceSpeed AS Interface_Speed, Nodes.Caption AS Node_Name, Interfaces.InterfaceName
       FROM 
      Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)
      WHERE (Interfaces.InterfaceName LIKE '%Giga%') OR (Interfaces.InterfaceSpeed = '10000000000')
      

       

      Thanks in advance.