Hi
iam running NPM 11.5.3 , can any tell me how to get Routing Neighbors report of routers running OSPF ?
strettle has a pretty good guide to doing this, Routing Neighbor state view resource.. valid for NPM 10.7
another approach is this one from alexslv Know Your Routing Neighbours
I have my own query that I use for this but their links come with guides
-Marc Netterfield
Loop1 Systems: SolarWinds Training and Professional Services
hi
i need have below mention report for my 250 nodes , i have build it by web report writer but issue is that on web based report writer iam not able to select all nodes in one time i have to individually select each note with make new content for each node which is very long process.
Is there any way to build report by selecting all node in one go.
make,
you should definately be able to do a dynamic selection in your report. Could you paste part of your report or maybe block our your syntax that applies to you?
Thx,
strettle
kindly find attached web report write image , which shows i can only select one node at a time.
so I was thinking about this.. and you don't need the routing neighbors table to check whether or not your router has an ospf process running.. as long as your router or switch is being monitored by NPM for its routing table.. try this
select distinct rp.displayname,n.sysname,n.dns,rn.nodeid from NPM_RoutingNeighbor rn
left join NPM_RoutingProtocol rp on rn.ProtocolID=rn.ProtocolID
left join nodes n on rn.nodeid=n.nodeid
where rp.displayname like 'OSPF'
it's a SQL query, not SQWL so you could put that into your report writer and it should give you what you want..
