NPC Query for InterfaceID

[d.pereyra]

Hello all, its posible to run a query to get all InterfaceID from Netqos PC ?  ( IfName, InterfaceID )

 

Thanks

 

Diego MP

[Christopher Pearson]

netqosportal.t_interface is likely to be a good starting point...

[MarlosBarroso]

Hi Diego. Is this the NPC product? If so you can query the table Chris mentioned:

 

select itemid as InterfaceID,IfName from t_interface;

[d.pereyra]

Thanks!

i resolve it with this query

\NETQOS\mysql51\bin>mysql nqrptr -t -e "select * from netqosportal.t_interface;" > t_interface_all.txt

 

i need to group routers/interfaces with the itemID. =)

 

Thanks

Diego MP