Unable get the router address for sql query on reporter database

book

Article ID: 142156

calendar_today

Updated On:

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

Attachments