1 Reply Latest reply on Jul 1, 2011 7:55 AM by AndyCoates

    Wrong Interface Speeds -- SQL Power Fix?

    kylebrandt

      Hi, 

      I am doing my initial add of my environment. A large amount of the interface speeds are wrong. 

      What is the best way to fix that across the board?

      I.E. something like the following?

       

      Update SolarWindsOrion.dbo.Interfaces

      Set CustomBandwidth = 1000000000

      WHERE

      InterfaceSpeed = 100000

        • Re: Wrong Interface Speeds -- SQL Power Fix?
          AndyCoates

          Almost - CustomBandwidth is a boolean value to let it know its custom, its the InBandwidth and OutBandwidth too which all need to be set.

          Something like this:

          UPDATE Interfaces
          SET CustomBandwidth = 1, InBandwidth = 1000000000, OutBandwidth = 1000000000
          WHERE
          InterfaceSpeed = 100000

          You can confirm the changes by looking at an Interface via the GUI.