How can I get a list of interfaces in NFA that have not been enabled but have seen netflow?

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

How can I get a list of interfaces that have not been enabled but have seen flow?

Environment

Component : NQRPTA - REPORTERANALYZER

Resolution

mysql -D reporter -unetqos -pnetqos -t -e "select r.devicename, inet6_ntoa(r.routeraddress), i.ifname, i.ifindex, i.ifmapid, from_unixtime(i.lastflow), i.enabled from routers r inner join interfaces i on r.id=i.routerid where i.lastflow > 0 and i.enabled='N' order by r.routeraddress;" > DisabledInterfacesWithFlow.csv

Or you can use the query below to get a list of interfaces that are not enabled, have seen flow, but have never been licensed:

mysql -D reporter -unetqos -pnetqos -t -e "select r.devicename, inet6_ntoa(r.routeraddress), i.ifname, i.ifindex, i.ifmapid, from_unixtime(i.lastflow), i.enabled from routers r inner join interfaces i on r.id=i.routerid where i.lastflow > 0 and i.enabled='N' and i.id not in (select interfaceid from agent_definitions) order by r.routeraddress;" > DisabledInteravcesWithFlow_NeverLicensed.csv