Mass change interface speed

awolfrom

I have over 200 firewalls that I monitor with Solarwinds and most of them have at least two Internet circuits for redundancy. We have a third party service that maintains all the information about the various ISPs that we use and they provide me with a webpage that I can easily scrape to get data about all of the circuits. What I would like to do is take that data and import it into Solarwinds so that I can see the actual bandwidth of the outside interfaces. I know how to do this on a manual basis by editing the interfaces but I would rather import this data automatically and set up a process to update this information on a schedule. What would be the best way for me to bulk import this data into Solarwinds?

christopher.t.jones123

@awolfrom, if you update the bandwidth statement on the interface itself within the firewall, SolarWinds will usually auto-adjust the configured bandwidth to match. This would be the preferred method as setting a custom bandwidth means that over time if the interface changes its often overlooked that SolarWinds has a custom bandwidth configured within it. If that still doesn't work it can absolutely be done via a powershell script. something like below.

# Pre-Reqs:
# 1. Ensure that the SolarWinds SDK, and powershell modules are installed on the main orion server.
# 2. CSV that contains InterfaceID in the first column, NodeID in the second column, InBandWidth in the third column, OutBandWidth in the fourth column No Column Headers.

import-Module SwisPowerShell
# Connect to SWIS


$hostname = Read-Host "Enter SolarWinds FQDN"
$cred = Get-Credential -Message "Enter Local Orion Account credential or Domain Credential in DOMAIN\USER format.  This script requires Orion Admin Permissions"
$swis = Connect-Swis -host $hostname -UserName $cred.UserName -Password $cred.GetNetworkCredential().Password

#check if account can connect
$connectcheck = @(Get-SwisData $swis "Select AllowNodeManagement FRom Orion.Accounts WHERE AccountID = '$($cred.Username)'") -ne $null
if ($connectcheck -ne $null) {
#check for node management rights
if ($connectCheck -eq 'Y') {
Write-Host "Connection check complete, account has Node Management Rights"
}
else {
Write-Host "Connection Check passed, Account check failed.  Please try again with an account with AllowNodeManagement access"
exit 1
}
}
else {
Write-Output "connection check failed, please check hostname and/or info services"
exit 1
}

#Import Data
if ($names -eq $true) {
$names = $null
}
#$names = import-csv \\server\file.txt
$filename = Read-Host -Prompt "Enter CSV Location (\\server\file or C:\dir\file)"
if (Test-Path $filename) {
Write-Output "File exists"

$ids = import-csv $filename -Header 'InterfaceID','NodeID','InBandWidth','OutBandwidth'
$count = $ips.length
}
else {
Write-Output "Bad file, exiting....."
exit
Write-Output $ids
}

foreach($id in $ips){
# Get Build URI for each Node to Update Caption
   Write-Output "Building update URI..."
    #build the URI
    $uri = "swis://$($hostname)/Orion/Orion.Nodes/NodeID=$($id.NodeID)/Interfaces/InterfaceID=$($id.InterfaceID)";
    Write-Output $uri
    $update= @{
       CustomBandwidth = true;
       InBandWidth = $id.InBandWidth;
       OutBandwidth = $id.OutBandWidth 
       }
# Set the IP Status
Write-Output "Update BandWidth"
Set-SwisObject $swis -Uri $uri -Properties $update;;

if ($error.length -ne 0){
Write-Output "Unable to update interface $($id.InterfaceID)"
sleep -m 500
}
else {
Write-Output "Unable to update interface $($id.InterfaceID)"
}}
Write-Output "Script Complete.  Exiting..."