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
Store

Moving Interfaces

Occasionally we have the need to move an customer to an differnet interface on a router. Currently it looks like there is no way to move their historical data to another interface....

Am I wrong on this, and is this functionality planned in future releases?

Find more posts tagged with

Accepted answers

All comments

clerum

Am I the only one who has had the promblem of moving circuits?

dos-netres

Tonight we will move some interfaces, and today I was wondering if this was possible.

I'll also keep the historical data.

If I found out how we can do this, I'll let you know.

Koen

DonYonce

Here is one method of moving Interface Traffic statistics from one interface to another. You will first need to know the NodeID and InterfaceID for the old and new Interfaces. Open System Manager, right-click on the interface and select "Interface Details". Write down the NodeID and InterfaceID for the old and the new interfaces.

Then open Database Manager and make a backup of your database just in case you mistype and delete something you needed. (If you have not already added your SQL server to Database Manager, you will need to do that first)

From within Database Manager, run the following SQL queries. You can run a query by right-clicking on the InterfaceTraffic table and selecting "Query Table". Replace the "Select top 1000 * from InterfaceTraffic" with one of the following SQL queries and hit Refresh to run the query.

First delete all historical statistics from the new interface using this SQL query : (replace nnn with the new NodeID and iii with the new Interface ID

Delete From InterfaceTraffic Where NodeID=nnn and InterfaceID=iii

Then move the old statistics from the Old Interface to the New Interface using this query : (replace nnn with the new NodeID, iii with the new InterfaceID, xxx with the old NodeID and yyy with the old InterfaceID)

Update InterfaceTraffic
Set NodeID=nnn, InterfaceID=iiii
Where NodeID=xxx AND InterfaceID=yyy

clerum

OK-

So a manual DB hit.

Not exactly something I feel comfortable with my NOC doing on the fly. Any word on this functionality making it into the manstream GUI.

Also a bit off topic but what about a remote event viewer that is realtime?