In CA Network Flow Analysis prior to version 9.3.0, NFA would perform a SNMP Discovery on a device and would insert every interface on a device into NFA.
In NFA 9.3.0 we introduced ifType Exclusion. This was done to limit the amount of interfaces to be inserted into NFA. The idea behind this new feature is that if the Interface on a device does not support Netflow that it is of no concern to anyone using NFA.
Prior to NFA 9.3.0 we would poll a device and insert thousands of unnecessary interfaces into NFA. This would cause performance issues throughout the system because of the hundreds of thousands of extra and unnecessary interfaces being in the databases.
The ifType Exclusion feature introduced in NFA 9.3.0:
Going forward after upgrading to NFA 9.3.0 or higher, NFA will ignore these types of interfaces during SNMP discovery and refresh processes. However interfaces that were discovered prior to NFA 9.3.0 and higher will still be in the database.
Here is a cleanup method you can use to remove these unnecessary interfaces from the databases. This method should only be used if on NFA 9.3.0 or above or if you are running NFA 9.2.1 with the ifType Rejection Patch Applied.
Run these commands in this EXACT ORDER ONLY for a complete cleanup:
- Mysql poller
delete p.* from persistent_map p inner join interfaces_snmp i on p.routerid=i.routerid and p.ifindex=i.ifindex and i.iftype in (1,18,37,100,101,102,103,104,134);
delete from interfaces_snmp where iftype in (1,18,37,100,101,102,103,104,134);
- Mysql reporter
delete from interfaces where iftype in (18,37,100,101,102,103,104,134);
delete from interfaces where iftype=1 and lastflow=0;
**Note we do not delete the ifType of 1 in the reporter.interfaces or the poller.persistent_map as Devices that have not had a successful SNMP poll will have a default iftype of 1 for all of its interfaces. It is however safe to delete the ifType 1 results in the poller.interfaces_snmp as this table will only be populated after a successful SNMP poll.**