Unable get the router address for sql query on reporter database

Article Id: 142156

Status: Published

Updated On: 20-12-2019 12:01

Products:

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction:

Not able to get the router address when we run the sql on reporter Database

Here is the sample query

select inet_ntoa(r.routeraddress), r.sysName, r.deviceAlias, i.name, i.description, i.ifalias from interfaces i inner join routers r on i.routerId=r.ID where ifName like 'Di1' or ifName like 'Di2' and enabled like 'Y' ;

Output

Environment:

Release : 10.0

Component : NQRPTA - REPORTERANALYZER

Resolution:

Modified query

select inet6_ntoa(r.routeraddress), r.sysName, r.deviceAlias, i.name, i.description, i.ifalias from interfaces i inner join routers r on i.routerId=r.ID where ifName like 'Di1' or ifName like 'Di2' and enabled like 'Y' ;