Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Removing Interfaces from Switches

Currently I'm monitoring all the interfaces on all our edge switches, so to bring down the number of elements monitored and release some of the load from the server I want to remove the interfaces from monitoring on all edge switches.

Is it possible to do this with a SQL script of something similar, I've got a custom property for all our edge switches so distinguishing them from other switches isn't a problem?

Any help would be much appreciated.

Thanks

Jon

Find more posts tagged with

Accepted answers

sedmo

Here are a couple of queries that should do what you need. The Where clause in each query will have to be modfied to match the name of your custom property field and the value to match in that field. XXXXXX in each query should be replaced with the name of your custom property field and YYYYYY needs to be the value in the custom property you want to match (i.e. edge).

The first query will just display a list of which interfaces will be deleted by the delete query. The second query will actually delete the interface records from the interfaces table.

Always make a backup of your database before making changes directly to the tables with SQL commands.

select nodes.caption as NodeName, interfaces.Caption as Interface from Nodes join interfaces on nodes.nodeid = interfaces.nodeid where nodes.XXXXXX = 'YYYYYY' order by nodes.caption

delete from interfaces where interfaces.nodeid in (select nodes.nodeid from nodes where nodes.XXXXXX = 'YYYYYY')

All comments

brian_duvall

I would think if you have a custom property that states a switch is "edge" and you want to remove all interfaces associated with that switch, you could write a sql query to find all nodes with the custom property, then find where those nodeID's exist in the Interface table and perform a delete on all those rows that have the nodeID's of edge switches. I believe db maintenance will remove all the orphaned data for interface IDs that no longer exist in database so that should clear all that out. I would let a solarwinds support person confirm this behavior but that should do in quickly.

jonchill

Thanks Brian, I though it shouldn't be to difficult to achieve. I just need someone to give me an idea of the script to run as I'm not SQL programmer.

sedmo

The first query will just display a list of which interfaces will be deleted by the delete query. The second query will actually delete the interface records from the interfaces table.

Always make a backup of your database before making changes directly to the tables with SQL commands.

select nodes.caption as NodeName, interfaces.Caption as Interface from Nodes join interfaces on nodes.nodeid = interfaces.nodeid where nodes.XXXXXX = 'YYYYYY' order by nodes.caption

delete from interfaces where interfaces.nodeid in (select nodes.nodeid from nodes where nodes.XXXXXX = 'YYYYYY')

sedmo

Sorry, I had a misplaced comma in the first query on the original post. I have corrected the problem.

jonchill

It works a treat but I've hit a slight problem there are certain types of interfaces I want to keep ie the trunk ports, I've tried adapting the script to allow me to filter based on a string eg all FastEthernet interfaces but can't get it to work.

Would it be possible to adapt the script for me, to allow me to filter the interfaces based on a string?

Thanks

Jon