Some background information:
As an ISP, interface statistic data is important to us, and amongst other things are used for planning where we need to increase capacity and looking at trends from previous holiday seasons (when traffic peaks the highest). When changes occur in the infrastructure, core network links are often moved to a new interface, either because we replaced the device with a different one or we are having hardware issues on that spesific port on the current device.
This results in vital interface data still being a part of the old interface not the new one, so we cant delete the old interface from NPM if we want to retain the data.
When this happens we need to move all the interface traffic data from the old interface to the new interface. We currently do this by running a SQL query, where we change the interfaceID from the old interface to the interfaceID of the new interface. This is a cumbersome task when a lot of interfaces has changed as we have to do it one by one.
This also makes it easier when using custom interface traffic graphs, where we can just replace the old interface with the new one and still get all the historical data for that connection.
The feature which is needed:
It would be great if moving interface statistics between interfaces was a core feature of SolarWinds, as the tables containing interface data sometimes is changed, making us redo the SQL query, and it would be a fairly easy feature to implement by devs.
This feature should have functionality to choose source interface, destination interface, interface data before and/or after given date and an option to delete old interface data if the target interface already contains data for the given timeperiod (as it can't be overwritten).
