Deleting interfaces, via Network Discovery?

I am looking to remove a certain interface type across an entire network from monitoring. Network Discovery has a very useful way of importing thousands of single interfaces types at once, does anyone know of a similar method to delete instead?

All suggestions are very welcome. I am looking to avoid doing what I know would work - manual or SQL.

Find more posts tagged with

delete_interfaces

seed_file

Accepted answers

All comments

bshopp

What version of Orion are you running? So you just want a method of finding all interfaces of a certain type already within Orion and quickly find them and delete correct?

Congo

I am running 9.1 SP3.
With I am looking to do something simple, such as how network discovery operates. I use a seed file to look at all effected routers, and can see all of the interfaces, I just wish that leaving them unchecked meant that it would remove them.

Thank you for the quick reply!

bshopp

So are these nodes already in Orion and you just want to delete a set of interface from Orion correct?

Have you used web node management? Go to Admin -> Manage Nodes -> in the top there is a drop down and select interfaces and then you can click on the column header "type" and filter by interface type. Select the interfaces you wish to remove from Orion and hit delete.

Let me know if this does not get you what you need

Congo

I tried this, and it works for some routers. Great idea!

However, when I attempt this on a router that has quite a few interfaces (a few thousand) it doesn't even try. I get this:

SELECT 'I' as Type, I.InterfaceID as ID, I.StatusLED, I.Caption, I.Index, I.Name FROM Orion.Interfaces I WHERE I.NodeID=1676 UNION (SELECT 'V' as Type, V.VolumeID, V.Icon as StatusLED, V.Caption, 0 AS Index, '' AS Name FROM Orion.Volumes V WHERE V.NodeID=1676)

There was an error processing the request.

about a second into it trying. Ive always known that Orion would have problems with a few of our larger routers.