Can't delete Unknown interface

Question

I have two network interfaces I can't seem to delete out of Orion. They're old port channels on a pair of Nexus 7K's going out to a border router. They're not in List Resources, so I should be able to just click them and click Delete, which appears to work (goes through the motions) but when you check back, they're still there. I even checked back a day later, and there they are.

How can I get rid of these?

blsanner · Accepted Answer

I would avoid deleting objects from the database. If you just delete it from the database, you may be leaving orphaned data behind in other tables. There is a stored procedure you can run to do the deletion though. For interfaces, the stored procedure is named swsp_DeleteInterface and takes the InterfaceID as a variable. To run it, launch SQL Server Management Studio and execute the following query:

USE SolarWindsOrion;

GO

EXEC dbo.swsp_DeleteInterface @id = %InterfaceID%;

Where you would replace %InterfaceID% with the actual interface ID of the interface you are trying to delete. This also assumes you went with the default database name of SolarWindsOrion.

Can't delete Unknown interface

Top Replies