select all physical ports with access as switchport mode.

Hi,Maybe someone has experience with the following:How can I use Solarwinds SDK and PowerShell to select all switch ports on all nodes with access as switchport mode?I want to use this selection to change the monitor option to "Display interface as unplugged rather than down".

Find more posts tagged with

sdk_powershell

Accepted answers

All comments

DGNetops

Do you have UDT or just NPM?

hebron1212

I'm not the OP, but we have the same challenge, and we have both UDT and NPM. How can we leverage those for a solution?

DGNetops

You will need to add values for the $username and $password field or swap out the $swis line for whatever you use to authenticate.

This is how you would do this via Powershell. If I were to put this into production in my own environment then I would want to wrap this in YAML to then have Ansible Tower make this available via a Template with additional values as the 'True' can be swapped out for a variable to pass in to set them as either true or false.

This is free to modify however you need but this does work as I tested it in my Lab

*Edit* I have updated the foreach loop to contain a if else check if its already set and to also write output on what interfaceID is getting changed to what value.

#connecting to SolarWinds API on localhost
$swis = connect-swis -username $username -password $password

#build the query to get scope of ports to update from SolarWinds
$PortQuery = @"
SELECT I.NodeID, I.InterfaceID, I.Unpluggable, I.PhysicalAddress, P.TrunkMode, I.URI
FROM Orion.NPM.Interfaces I 
JOIN Orion.UDT.Port as P on I.NodeID = P.NodeID
WHERE P.TrunkMode = 2 and I.PhysicalAddress = P.MACAddress

<#
TrunkMode = 1 means it is in Trunk Mode
TrunkMode = 2 means it is an Access Mode Port
TrunkMode = 0 means it is a routed interface or a vlan SVI
#>

#execute the query and then take bulk array and loop through updating each interface to unpluggable.
$PortstoChange = Get-SwisData $swis $PortQuery

foreach ($port in $portstoChange){
    If ($port.Unpluggable -ne 'True'){
        Set-SwisObject -SwisConnection $swis -Uri $port.URI -Properties @{Unpluggable='True'}
        "Setting InterfaceID: $($port.InterfaceID) with Unpluggable = False to Unpluggable = True"
    }
    Else{
        "InterfaceID: $($port.InterfaceID) already has Unpluggable set to True"
    }
}

DGNetops

Apologies my original answer got flagged as spam - awaiting an appeal. In meantime here is a powershell way to perform this action. You can modify however you want.


#connecting to SolarWinds API on localhost
$swis = connect-swis -username $username -password $password

#build the query to get scope of ports to update from SolarWinds
$PortQuery = @"
SELECT I.NodeID, I.Caption, I.CustomProperties.Circuit, I.InterfaceID, I.Unpluggable, I.PhysicalAddress, P.TrunkMode, I.URI
FROM Orion.NPM.Interfaces I 
JOIN Orion.UDT.Port as P on I.NodeID = P.NodeID
WHERE P.TrunkMode = 2 and I.PhysicalAddress = P.MACAddress

<#
TrunkMode = 1 means it is in Trunk Mode
TrunkMode = 2 means it is an Access Mode Port
TrunkMode = 0 means it is a routed interface or a vlan SVI
#>

#execute the query and then take bulk array and loop through updating each interface to unpluggable.
$PortstoChange = Get-SwisData $swis $PortQuery

foreach ($port in $PortstoChange){
    If ($port.Unpluggable -ne 'True' AND $port.Circuit -eq 'False'){
        Set-SwisObject -SwisConnection $swis -Uri $port.URI -Properties @{Unpluggable='True'}
        "Setting InterfaceID: $($port.InterfaceID) with Unpluggable = False to Unpluggable = True"
    }
    Else{
        "InterfaceID: $($port.InterfaceID) already has Unpluggable set to True"
    }
}

For my environment the more I thought about it the more I figured this would be a good idea as well so I adjusted the script further than what is curently shown above to only match against Cisco and Palo Alto devices as well as to exclude interfaces that we state are circuits since we still want those to show as Down.