Re: [Netdisco] query to find discovered but inaccessible neighbors

[Max B. <ma...@wa...>]

Brian,

Try doing a  [Device Search] -> [Broken Topology Links]
and that will find everything listed in Red. 

For the second one, I don't have anything in the GUI, and it might be easier
to implement it on the command line,  since you need a list to feed to
something else. 

For now here's some SQL :

    select d.dns,p.port,p.remote_ip,p.remote_port 
        from device d,device_port p
        where d.ip = p.ip and p.remote_ip is not null 
        order by d.dns;

That'll give you the name of the switch,the port, its neighbor and neighbor
port.

Run it from sql/pg_run.

I think you can redirect to a file from inside psql.  Run \?  inside pg_run to
find out. 

-m

PS. I promise to get to everyone else's questions... it just might not be
until my holiday break from gradschool.


On Tue, Nov 25, 2003 at 10:49:07AM -0500, Brian Wilson wrote:
> I recently ran across an issue where some switches had been incorrectly 
> configured (someone fat fingered the snmp string) so it was never 
> discovered by our monitoring system.  The only reason I found it was 
> that it was marked in red within netdisco.  So, my question is, is 
> there a query I can run to find all discovered but inaccessible 
> neighbors so I can find out what other devices might be misconfigured?
> 
> Also, we are getting ready to implement spantree root guard on all our 
> access switch, so I also wanted to figure out how to query switches and 
> find out which port neighbors were on so that we don't enable root 
> guard on those ports.  So, a query to find this would be great too.
> 
> Thanks,
> Brian
> 
> --
> Brian Wilson                                  wi...@nc...
> Network Analyst                               W: 919.513.3472
> Communication Technologies                    F: 919.513.1893
> North Carolina State University        http://www.ncstate.net