4 Replies Latest reply on Oct 16, 2014 10:01 AM by njoylif

    Report on Interface Duplex Setting

      I want to create a report listing all the interfaces of a switch with the duplex settings.  How would I get this info?

       

      Thanks

        • Re: Report on Interface Duplex Setting
          darryld

          You will need a UnDP to collect the duplex setting. Most (cisco) devices support the etherlike mib so 1.3.6.1.2.1.10.7.2.1.19 would be a good place to start. Then edit the Current Interface Status report in Report Writer to include the new data

            • Re: Report on Interface Duplex Setting

              Ok,  I created the custom poller for that MIB.  I then edited the report but I don't see how to display the results of the poller.

               

              Thanks

                • Re: Report on Interface Duplex Setting
                  darryld

                  If the custom poller option doesn't appear in the drop downs you may need to experiment with other report types or it might be simpler to start a new report and select the sql option then paste something like

                   

                  SELECT     CustomPollers.UniqueName, Interfaces.InterfaceName, CustomPollerStatus.Status

                  FROM         CustomPollerStatus INNER JOIN

                                        CustomPollerAssignment ON CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID INNER JOIN

                                        CustomPollers ON CustomPollerAssignment.CustomPollerID = CustomPollers.CustomPollerID INNER JOIN

                                        Interfaces ON CustomPollerAssignment.InterfaceID = Interfaces.InterfaceID

                  WHERE     (CustomPollers.UniqueName = N'dot3StatsDuplexStatus')

                   

                  into it 

                   

                  Add as many fields from the interfaces table as you need

                  dot3StatsDuplexStatus should be replaced by the name you gave your UnDP

                • Re: Report on Interface Duplex Setting
                  njoylif

                  FYI, this UnDP didn't work for me for my routers, but the UnDP here did.  good luck