NetOps showing routers with no interfaces

book

Article ID: 205669

calendar_today

Updated On:

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

Cause

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

Environment

Release : 20.2

Component : NQRPTA - REPORTERANALYZER

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)'