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
Release : 10.0
Component : NQRPTA - REPORTERANALYZER
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' ;