Re: [Netdisco] using command line

[John K. <kok...@ge...>]

Robert

This is the ouput from the switch.

vlan   mac address     type        protocols               port
-------+---------------+--------+---------------------+--------------------
  32    0004.5a7f.c734   dynamic ip                     FastEthernet6/30

------------------------------------------------------------------------------
This is the output from the sql statement.

141.161.xx.xx   | SWQ-6B-C451        | FastEthernet6/30    |    39
----------------------------------------------------------------------------------------------

 
John Kokidko

Robert Kerr wrote:

>On Tue, 2005-02-15 at 20:49, John Kokidko wrote:
>  
>
>>This is the output I received from the sql statement...
>>    
>>
>
>  
>
>>netdisco=> select d.ip,i.dns,d.port,count(distinct(n.mac)) from
>>netdisco-> device_port d,node n,device i where i.ip=d.ip and
>>d.ip=n.switch and
>>netdisco-> d.port=n.port and d.remote_ip is null and n.active=true
>>group by
>>netdisco-> d.ip,d.port,i.dns having count(distinct(n.mac)) > 1 order
>>by
>>netdisco-> count(distinct(n.mac)) desc; 
>>    
>>
>
>
>  
>
>>       ip        |                   dns                    |       
>>port         | count 
>>-----------------+------------------------------------------+---------------------+-------
>> 141.161.xx.xx  | NSO-BDF-C552      | 5.1                 |  1400
>> 141.161.xx.xx | dar-4th-c191              | 8                   | 
>>1371
>> 141.161.185.186 | lvy-3rd-c41           | 252                 |   375
>> 141.161.xx.xx | dar-6th-c191           | 3                   |   252
>> 141.161.xx.xx   | vlc-2y-c191           | 17                  |   244
>> 141.161.xx.xx  | vlc-8y-c192            | A                   |   192
>> 141.161.xx.xx| gulc-cat-6513           | 6.3                 |   182
>>    
>>
>
>1400? that's a lot of MACs for one port. Does the 'Device ports with
>multiple nodes attached' option on the device search page of the web
>interface show the same?
>
>Are those ports perhaps uplinks to other switches that haven't properly
>been flagged as such? The SQL query checks that device_port.remote_ip is
>null to try and ensure it doesn't output uplink ports. If they're not
>uplinks then I'm not sure what's going on, you could try having a look
>at the node table and seeing what it thinks are on those ports.
>
>  
>