SQL query for updatingTopology and Routing fields on nodes

mr.e

We just upgraded Orion NPM to v10.5.  After this, we noticed that many of our routers did not show Routing information. It turns out that the Routing boxes were not checked.  We also noticed that many of our Layer 3 devices did not have the Layer 3 boxes checked either.  Now, we have over 300 routers and over 1000 Layer 3 switches.  So, as you will understand, it would take a lot of time for us to correct these via the Orion website. 

So, we would like to know if there is a SQL query that we could run, which would tell us the devices that need to be corrected for the Routing and Topology Layer 2 and Layer 3 boxes.  Any ideas???

adambudwill

Hi Newkidd2, from another thread I've read as well as my recent SolarWinds case (477855) they do not support bulk add or mass add of the items in the List Resources (Topology, Wireless, CPU and Memory, Hardware health sensors, etc). You can do a mass delete using SQL statements but adding is more difficult since each node may or may not support some pollers so blind adding them via a SQL statement without knowing what is supported I assume may generate some extra errors or problems. I was told they would put in a feature request, but after looking at the NPM 10.5 "What we're working on" thread it doesn't sound promising. I had to do it by manually. Good luck to you.