2 Replies Latest reply on Aug 8, 2018 8:51 AM by rogdog

    Is Port Speed/Duplex available in an UDT report

    lhoyle

      I know how to find speed/duplex once I put in an IP address of the host I looking for, but to save me from having to look through 800+ hosts to record the speed/duplex of the port (our locations are spread over 5-100+ acres), I was hoping to find this data in a field I can pump out a report of.

       

      Even better, I'd like to report on all port speed and duplex when the port is in use and has a specific MAC manufacturer code.

       

      Is this wishful thinking?

       

      TYIA

       

      Lee

        • Re: Is Port Speed/Duplex available in an UDT report
          joepoutre

          Hello Lee,

           

          Have you checked the options in Report Writer? I just looked and see that one can find the Interface Speed, both Administrative Status and Operational Status, and Physical Address (MAC). I do not see Duplex, though.

           

          Regards,

          Joe

            • Re: Is Port Speed/Duplex available in an UDT report
              rogdog

              If you can't do it with a normal report you could try creating a report using a custom table with SWQL as the datasource

               

              Example SWQL 

               

              SELECT DISTINCT
              
              
              u.Node.Caption As Node,
              Name As Interface, 
              PortDescription,
              
              
              CASE
                  WHEN Speed <= 100000000 THEN CONCAT(Speed/1000000,'MB')
                  ELSE CONCAT(Speed/1000000000,'GB')
              END AS Speed,
              
              
              CASE
                  WHEN Duplex = 1 THEN 'Full'
                  ELSE 'Half'
              END as Duplex,
              
              
              CASE 
                  WHEN Trunkmode = 0 then 'Access' 
                  WHEN Trunkmode = 1 then 'Trunk' 
                  WHEN Trunkmode = 2 then 'Undefined' 
                  ElSE concat(TrunkMode)
              END AS TrunkMode,
              
              
              CASE 
                  WHEN u.Endpoints.ConnectionType = 1 THEN 'Direct'
                  WHEN u.Endpoints.ConnectionType = 2 THEN 'InDirect'
                  ELSE concat(u.Endpoints.ConnectionType)
              END AS ConnectionType,
              
              
              oui.Company AS Vendor,
              u.Endpoints.Endpoint.MACAddress AS EndPoint_MAC,
              u.Endpoints.Endpoint.IPAddresses.IPAddress AS EndPoint_IP,
              u.Endpoints.Endpoint.IPAddresses.DNSNames.DNSName AS EndPoint_DNS
              
              
              
              
              FROM Orion.UDT.Port u
              LEFT JOIN Orion.UDT.OUIReport oui ON u.Endpoints.EndpointID = oui.EndpointID 
              
              
              WHERE IsMOnitored = TRUE -- Only display UDT Ports that are being monitored
              AND OperationalStatus = 1 -- Port Status = UP
              AND u.Endpoints.ConnectionType = 1 -- 1 = Direct, 2 = Indirect

              .

              1 of 1 people found this helpful