Can I enable and change the Custom Bandwidth property from 1000 to 10000 in bulk, to about 200 interfaces? I am assuming I should be able to do this in SQL but I am a complete newbie when it comes to SQL.
How can you identify these interfaces and nodes? Are they all the same machine type and interface type - or name - or are they the only interfaces you have at 1000? I think I would try to do this through the manage nodes/interfaces page if you can return all 200 interfaces through the search or filtering.
If not then before you can execute this very simple SQL update you will need to limit it to just these interfaces based on your above criteria. So start by getting a SELECT statement together that returns only the interfaces you want to affect then we can modify it into an UPDATE statement.
Orion SWIS
https://your hostname/Orion/Admin/swis.aspx
SELECT top 10 Alias, Caption, CustomBandwidth, InBandwidth, OutBandwidth, InterfaceCaption, InterfaceIcon, InterfaceID, InterfaceSpeed FROM Orion.NPM.Interfaces
Hello Bluefunelmental,
Thanks for your responce. All of these interfaces beging with irb in the interfacename field. So I can identify all the interfaces I want chagned with the following select query.
SELECT * FROM [dbo].[Interfaces]
WHERE [InterfaceName] Like 'irb%'
I'm with bluefunelemental - do it through the ManageNodes page. While I like to think of myself as a SQL jocky too, the truth is that using the Solarwinds tools may be slightly slower, but there are a TON of safeguards build into the web interface to keep you from the OhNoSecond (http://en.wiktionary.org/wiki/ohnosecond).
So in manage nodes change the selector to interfaces then type irb.
if that returns only your interfaces then you can select all and edit properties.
Awesome I knew there had to be an easier way to do this LOL. Thanks for the help.
Manage Nodes -> Click on the SHOW option and change to interface
Then search for "IRB" - select all items (top check box), and then it should ask you to click here to select all "however many interfaces there are"
Once all interfaces are checked, then click EDIT PROPERTIES.
On the next page it will list all your interfaces, Scroll down to the BANDWIDTH portion.
Click the check box for CUSTOM BANDWIDTH
Then change the 1000 to 10,000 (I am assuming you want this in Transmit and Receive, so change both)
Click Submit.
I agree with Leon Adato & bluefunelemental that this is easier through the Manage Nodes Page.
