How to remove Routers/Interfaces without losing the history?

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

How to remove Routers/Interfaces without losing the history from the MySQL DB?

Environment

Netflow Flow Analysis

Resolution

Example for Router IP Address: 100.200.300.400

1 - Stop all NFA services on Harvester and NFA Console machines:

2 - Queries to Delete on Harvester machine:

mysql
use harvester
select * from routers where inet6_ntoa(router)='100.200.300.400'; (Note the routerID)
select * from interfaces where inet6_ntoa(router)='100.200.300.400';
delete from routers where inet6_ntoa(router)='100.200.300.400';
delete from interfaces where inet6_ntoa(router)='100.200.300.400';

select * from persistent_map where routerid='x'; (Inform the routerID from first select)
delete from persistent_map where routerid='x';

NFA Console machine:

use reporter
select ID from routers where deviceName = '100.200.300.400'; (Note the routerID)
select * from interfaces where routerId = 'nnnnnnn'; (Inform the routerID from select above)
delete from routers where deviceName = '100.200.300.400';
delete from interfaces where routerId = 'nnnnnnn'; (Inform the routerID from select above)

3 - Start all NFA services on Harvester and NFA Console machines

4 - Make sure that the desired interfaces show back up and are enabled

5 - Wait 15 minutes to Validate

Additional Information