NetOps showing routers with no interfaces

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

When I search my routers in NetOps Portal, I see routers with no active/available interfaces

Environment

Release : 20.2

Component : NQRPTA - REPORTERANALYZER

Cause

NetOps will pull ALL routers from the NFA database, even if they have no interfaces. NFA will not show these routers.

Resolution

 This will remove the empty routers from the NFA database:

1) Log into the NFA Console

2) mysql reporter

3) 'delete from routers where id not in (select routerid from interfaces)'