Interface Cleanup Question

I am needing to clean up thousands of down and unplugged interfaces. I have a valid list of 5096 interfaces IDs targeted for deletion. It is not feasible to do this from the WEBUI.

I found this article on how to cleanup these interfaces and believe it cannot be done from the WEBUI do to the large qty.

How to Delete Unknown or Down interfaces by bulk in Orion (site.com)

This example query here.

delete from Interfaces where InterfaceID=953

insert into DeletedInterfaces (InterfaceId) values (953)

Does anyone know how and where I run that ?

If I search in SWQL I do not even see a table called DeletedInterfaces

Find more posts tagged with

network_monitoring

npm

Accepted answers

All comments

brscott

1) Those are SQL statements for directly modifying the MS-SQL databases.

2) Don't do that.

3) See #2

4) and just for clarity. Don't do that.

That would need to be an API call to do what you want. https://github.com/solarwinds/OrionSDK/wiki

I don't have the code for deleting an interface, but maybe someone around here does.

mmayer5823

Hi Brian,

Thanks for your reply. Well, this just became a lot more complicated. Seems like this would be a common task.

brscott

Well, since I also needed to do this, I figured I would just go ahead and write something up. Yes it's more complicated than it should be, I agree there should be a way to do this in the web interface easier, but this is the current state of things.

After you have the SDK installed, here is a bit of powershell code that should do what you want.

Remove the comment from the "Remove-swisobject" line to actually do the delete.

Import-Module SwisPowerShell

$creds = Get-Credential

$OrionServer = 'YourOrionServer.example.com'

$swis = Connect-Swis -Credential $Cred -Hostname $OrionServer

$iList = Get-SwisData -SwisConnection $swis -Query "

SELECT

i.Node.Caption as Node,

InterfaceID,

Name,

TypeName,

LastChange,

Status,

Uri

FROM Orion.NPM.Interfaces i

Where

--Make sure that is at least one Up interface on the node.

--I do not want to delete all of the interfaces of a node that just happens to be down for a while.

(select count(i2.interfaceid) as c from Orion.NPM.Interfaces i2 where status=1 and i2.nodeid=i.nodeid) > 1 AND

-- This is not a temporary condition, it's been in this state for more than 2 days

DayDiff(LastChange,GetUtcDate()) > 2 AND

--Status is unknown

i.Status = 0

$iList |

ForEach-Object {

$i = $_

Write-Host "Deleting $($i.Name) on $($i.Node). It has been unknown since $($i.LastChange)"

# Remove-SwisObject -SwisConnection $swis -Uri $i.Uri

}

brscott

Note: I ran this in powershell 5

sum_giais

To do this with the API, get and install SwisPowerShell (https://www.powershellgallery.com/packages/SwisPowerShell/) on a system you could connect to your solarwinds server with.

Since you have a valid list of interface ID's you could plug that easily into the query or the powershell below to remove those interfaces. Below is an example. You would format your list of Interface ID's just like it is in line 9, e.g. (123, 456, 789) and SwisPowerShell would do the work for you.

$swis = Connect-Swis -Hostname 'mySolarWindsServer' -Username 'user' -Password 'pass123'

$query = @"
	SELECT
		 i.Name
		,i.InterfaceID
		,i.Uri
	FROM Orion.NPM.Interfaces AS i
	WHERE i.InterfaceID IN (123, 456, 789)


$selection = Get-SwisData -SwisConnection $swis -Query $query

ForEach ($entity in $selection) {

	Remove-SwisObject -SwisConnection $swis -Uri $entity.Uri

	Write-Output("REMOVED:: " + $entity.Name + " (URI - " + $entity.Uri + ")")

}

mmayer5823

Thanks Brian and sum_giais for your replies, I am testing today.