Hi,
I would like to generate a report for several sites that shows the next-hop for a couple subnets only. I see how to do a report for all routes, but that isn't very economical. Is there a way to do this for specified destinations only?
The canned report is actually a Custom SQL Query, so you would need to update that query with a WHERE Statement to filter your information.
Example:
WHERE NcmRouteTable.Destination LIKE '10.10.%'
Don't know anything about diving into query modifications, but I'll see what I can do. Is there an ability to have a tab on a view that shows this information for many selected sites? A tab where I can click on and it will show specified sites and the next hop for specific destinations?
BTW, I know each individual node has a network tab that shows next hops, but I want an aggregated nodes page. Possible?
For anyone else that might see this, it was much easier to use the dynamic query option and associated drop downs in order to get the report I wanted as compared to writing my own query requests. I actually downloaded the SWQL SDK and started testing queries and it crashed our Solarwinds server.
