Send netdisco-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Issue with H3C/HP 5130 Switches (Jeroen van Ingen)
2. Re: Issue with H3C/HP 5130 Switches (Muris)
3. (no subject) (Andy Sainsbury)
--- Begin Message ---
Hi Muris,
Looks like there's a large amount of timeouts, almost every large table
that Netdisco tries to poll fails because of that.
Have a look at the occurrences of "BULKWALK Timeout" in the logs that
you pasted.
Try raising the snmptimeout config parameter to eg 10 seconds (default
is one) and see if that helps.
https://metacpan.org/pod/distribution/App-Netdisco/lib/App/Netdisco/Manual/Configuration.pod#snmptimeout
Regards,
Jeroen van Ingen
ICT Service Centre
University of Twente, P.O.Box 217, 7500 AE Enschede, The Netherlands
On 05/20/2016 03:33 AM, Muris wrote:
Hi, I need some assistance from the netdisco community to try get the
H3C/HP 5130 switches to work properly. We are deploying these as IRF
stacks accross many locations, however MAC suck and ARP nip are not
working properly, and even displaying the device modules. It basically
shows up blank that there is nothing connected, however it does pickup
significant mac addresses connected.
Here is the full output on the discovery. This occurs on netdisco v1 or
v2 doesnt matter which version. I think either the H3C mibs is the issue
or some H3C discovery layer needs to be modified in some way to report
data. I have other 5800 series H3C switches which work ok, but this
model doesnt.
Any help or assistance will be most appreciated as we keen to have these
working properly. I have pasted the below outputs. Note that it is
connected to a cisco switch above with LLDP enabled and this one also
has LLDP enabled.
$ netdisco -D -d 10.18.182.2
n e t d i s c o
--------------------------------------------------
Using Config File : /usr/share/netdisco/netdisco.conf
Loading topology information from /usr/share/netdisco/netdisco-topology.txt
3 entries loaded
[10.18.182.2] Discover starting
get_device(10.18.182.2)
get_device(10.18.182.2) - Connecting using cached info:
10.18.182.2/e/2 <http://10.18.182.2/e/2>
create_device(10.18.182.2,e,2*,AutoSpecify,bw:default)
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 :
.1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.31
SNMP::Info::device_type() layers:01001110 id:25506 sysDescr:"HPE Comware
Platform Software, Software"
SNMP::Info::specify() - Changed Class to SNMP::Info::Layer3::H3C.
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 :
.1.3.6.1.2.1.1.1.0
[10.18.182.2] Device Type : SNMP::Info::Layer3::H3C
[10.18.182.2] Fetching Device Info
SNMP::Info::_global router_ip : OSPF-MIB::ospfRouterId.0 :
.1.3.6.1.2.1.14.1.1.0
SNMP::Info::_global(router_ip) NOSUCHOBJECT at /usr/sbin/netdisco line 1429
SNMP::Info::_load_attr ospf_ip : OSPF-MIB::ospfHostIpAddress :
.1.3.6.1.2.1.14.6.1.1
SNMP::Info::_load_attr ip_index : IP-MIB::ipAdEntIfIndex :
.1.3.6.1.2.1.4.20.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 2777
SNMP::Info::_load_attr i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 2778
SNMP::Info::_load_attr i_description : IF-MIB::ifDescr :
.1.3.6.1.2.1.2.2.1.2
SNMP::Info::_load_attr ip_netmask : IP-MIB::ipAdEntNetMask :
.1.3.6.1.2.1.4.20.1.3
SNMP::Info::_validate_autoload_method(vtp_d_name) Unable to resolve method.
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance :
.1.3.6.1.2.1.1.3.0
SNMP::Info::_global contact : SNMPv2-MIB::sysContact.0 : .1.3.6.1.2.1.1.4.0
SNMP::Info::_global name : SNMPv2-MIB::sysName.0 : .1.3.6.1.2.1.1.5.0
SNMP::Info::_global location : SNMPv2-MIB::sysLocation.0 :
.1.3.6.1.2.1.1.6.0
SNMP::Info::_global ports : IF-MIB::ifNumber.0 : .1.3.6.1.2.1.2.1.0
SNMP::Info::_global mac : IF-MIB::ifPhysAddress.1 : .1.3.6.1.2.1.2.2.1.6.1
SNMP::Info::_global serial1 : CISCO-SMI::temporary.6.3.0 :
.1.3.6.1.4.1.9.3.6.3.0
SNMP::Info::_global(serial1) NOSUCHOBJECT at /usr/sbin/netdisco line 2837
SNMP::Info::_load_attr e_parent : ENTITY-MIB::entPhysicalContainedIn :
.1.3.6.1.2.1.47.1.1.1.1.4
SNMP::Info::_load_attr e_serial : ENTITY-MIB::entPhysicalSerialNum(1) :
.1.3.6.1.2.1.47.1.1.1.1.11.1
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info::_validate_autoload_method(ps1_type) Unable to resolve method.
SNMP::Info::_validate_autoload_method(ps2_type) Unable to resolve method.
SNMP::Info::_global ps1_status : HH3C-LswDEVM-MIB::hh3cDevMPowerStatus.1
: .1.3.6.1.4.1.25506.8.35.91
SNMP::Info::_global ps2_status : HH3C-LswDEVM-MIB::hh3cDevMPowerStatus.2
: .1.3.6.1.4.1.25506.8.35.92
SNMP::Info::_global fan : HH3C-LswDEVM-MIB::hh3cDevMFanStatus.1 :
.1.3.6.1.4.1.25506.8.35.9.1.1.1.2.1
SNMP::Info::_validate_autoload_method(slots) Unable to resolve method.
SNMP::Info::_load_attr entPhysicalMfgName :
ENTITY-MIB::entPhysicalMfgName(1) : .1.3.6.1.2.1.47.1.1.1
SNMP::Info::_load_attr entPhysicalSoftwareRev :
ENTITY-MIB::entPhysicalSoftwareRev(2) : .1.3.6.1.2.12
[10.18.182.2] Fetching Interface Information
SNMP::Info::_load_attr i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_attr i_type : IF-MIB::ifType : .1.3.6.1.2.1.2.2.1.3
SNMP::Info::_load_attr i_mtu : IF-MIB::ifMtu : .1.3.6.1.2.1.2.2.1.4
SNMP::Info::_load_attr orig_i_speed : IF-MIB::ifSpeed : .1.3.6.1.2.1.2.2.1.5
SNMP::Info::_load_attr i_speed_high : IF-MIB::ifHighSpeed :
.1.3.6.1.2.1.31.1.1.1.15
SNMP::Info::_load_attr i_mac : IF-MIB::ifPhysAddress : .1.3.6.1.2.1.2.2.1.6
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 2876
SNMP::Info::_load_attr i_up : IF-MIB::ifOperStatus : .1.3.6.1.2.1.2.2.1.8
SNMP::Info::_load_attr i_up_admin : IF-MIB::ifAdminStatus :
.1.3.6.1.2.1.2.2.1.7
SNMP::Info::_load_attr i_alias : IF-MIB::ifAlias : .1.3.6.1.2.1.31.1.1.1.18
SNMP::Info::_load_attr orig_i_name : IF-MIB::ifName :
.1.3.6.1.2.1.31.1.1.1.1
SNMP::Info::_load_attr el_index : EtherLike-MIB::dot3StatsIndex :
.1.3.6.1.2.1.10.7.2.1.1
SNMP::Info::_load_attr el_duplex : EtherLike-MIB::dot3StatsDuplexStatus
: .1.3.6.1.2.1.10.7.2.1.19
SNMP::Info::_load_attr i_duplex_admin :
HH3C-LswINF-MIB::hh3cifEthernetDuplex : .1.3.6.1.4.1.25506.83
SNMP::Info::_load_attr bp_index : BRIDGE-MIB::dot1dBasePortIfIndex :
.1.3.6.1.2.1.17.1.4.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 2882
SNMP::Info::_load_attr stp_p_state : BRIDGE-MIB::dot1dStpPortState :
.1.3.6.1.2.1.17.2.15.1.3
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 2882
SNMP::Info::_load_attr bp_index : BRIDGE-MIB::dot1dBasePortIfIndex :
.1.3.6.1.2.1.17.1.4.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 2883
SNMP::Info::_load_attr qb_i_vlan : Q-BRIDGE-MIB::dot1qPvid :
.1.3.6.1.2.1.17.7.1.4.5.1.1
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 2883
SNMP::Info::_validate_autoload_method(i_pvid) Unable to resolve method.
SNMP::Info::_load_attr i_lastchange : IF-MIB::ifLastChange :
.1.3.6.1.2.1.2.2.1.9
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 2885
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance :
.1.3.6.1.2.1.1.3.0
SNMP::Info::_global(uptime) Timeout at /usr/sbin/netdisco line 2888
[10.18.182.2] 320 Interfaces.
SNMP::Info::_validate_autoload_method(i_ssidlist) Unable to resolve method.
[10.18.182.2] Fetching VLAN Information
SNMP::Info::_load_attr bp_index : BRIDGE-MIB::dot1dBasePortIfIndex :
.1.3.6.1.2.1.17.1.4.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3028
SNMP::Info::_load_attr qb_i_vlan : Q-BRIDGE-MIB::dot1qPvid :
.1.3.6.1.2.1.17.7.1.4.5.1.1
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3028
SNMP::Info::_load_attr qb_cv_egress :
Q-BRIDGE-MIB::dot1qVlanCurrentEgressPorts : .1.3.6.1.2.1.17.7.4
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3029
SNMP::Info::_load_attr qb_v_egress :
Q-BRIDGE-MIB::dot1qVlanStaticEgressPorts : .1.3.6.1.2.1.17.7.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3029
SNMP::Info::_load_attr bp_index : BRIDGE-MIB::dot1dBasePortIfIndex :
.1.3.6.1.2.1.17.1.4.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3029
[10.18.182.2] Scrubbing VLANs from device_port_vlan table... 0 removed
[10.18.182.2] Scrubbing VLANs from device_vlan table... 0 removed
SNMP::Info::_load_attr v_name : Q-BRIDGE-MIB::dot1qVlanStaticName :
.1.3.6.1.2.1.17.7.1.4.3.1.1
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3063
SNMP::Info::_load_attr v_name : Q-BRIDGE-MIB::dot1qVlanStaticName :
.1.3.6.1.2.1.17.7.1.4.3.1.1
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3064
[10.18.182.2] 0 VLAN Interfaces, 0 names.
[10.18.182.2] Fetching Power Information
SNMP::Info::_load_attr peth_power_watts :
POWER-ETHERNET-MIB::pethMainPsePower : .1.3.6.1.2.1.105.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3110
[10.18.182.2] 0 Power Modules
[10.18.182.2] Fetching Module Information
SNMP::Info::_load_attr entPhysicalDescr : ENTITY-MIB::entPhysicalDescr :
.1.3.6.1.2.1.47.1.1.1.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 1893
[10.18.182.2] 0 Modules.
[10.18.182.2] Fetching Neighbor Information
SNMP::Info::_global lldp_sys_cap : LLDP-MIB::lldpLocSysCapEnabled.0 :
.1.0.8802.1.1.2.1.3.6.0
SNMP::Info::_global(lldp_sys_cap) Timeout at /usr/sbin/netdisco line 1461
SNMP::Info::_load_attr lldp_rem_id : LLDP-MIB::lldpRemChassisId :
.1.0.8802.1.1.2.1.4.1.1.5
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 1461
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
[10.18.182.2] ! CDP not Enabled.
netdisco -D -A 10.18.182.2
n e t d i s c o
--------------------------------------------------
Using Config File : /usr/share/netdisco/netdisco.conf
arpnip(10.18.182.2) :
get_device(10.18.182.2)
get_device(10.18.182.2) - Connecting using cached info:
10.18.182.2/e/2 <http://10.18.182.2/e/2>
create_device(10.18.182.2,e,2*,AutoSpecify,bw:default)
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 :
.1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.31
SNMP::Info::device_type() layers:01001110 id:25506 sysDescr:"HPE Comware
Platform Software, Software"
SNMP::Info::specify() - Changed Class to SNMP::Info::Layer3::H3C.
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 :
.1.3.6.1.2.1.1.1.0
[10.18.182.2] Device Type : SNMP::Info::Layer3::H3C
mac_getportmacs() ... found 101612 MACs.
SNMP::Info::_load_attr orig_at_paddr : IP-MIB::ipNetToMediaPhysAddress :
.1.3.6.1.2.1.4.22.1.2
SNMP::Info::_load_attr orig_at_netaddr : IP-MIB::ipNetToMediaNetAddress
: .1.3.6.1.2.1.4.22.1.3
[10.18.182.2] Processed 122 ARP Cache entries.
SNMP::Info::_load_attr ip_netmask : IP-MIB::ipAdEntNetMask :
.1.3.6.1.2.1.4.20.1.3
Found subnet 10.xx/27
Found subnet 10.xx/26
Found subnet 10.xx/23
Found subnet 10.xx/28
arpnip6(10.18.182.2) :
get_device(10.18.182.2)
get_device(10.18.182.2) - Connecting using cached info:
10.18.182.2/e/2 <http://10.18.182.2/e/2>
create_device(10.18.182.2,e,2*,AutoSpecify,bw:default)
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 :
.1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.31
SNMP::Info::device_type() layers:01001110 id:25506 sysDescr:"HPE Comware
Platform Software, Software"
SNMP::Info::specify() - Changed Class to SNMP::Info::Layer3::H3C.
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 :
.1.3.6.1.2.1.1.1.0
[10.18.182.2] Device Type : SNMP::Info::Layer3::H3C
SNMP::Info::_load_attr ip_n2p_phys_addr :
IP-MIB::ipNetToPhysicalPhysAddress : .1.3.6.1.2.1.4.35.1.4
SNMP::Info::_load_attr c_inet_phys_addr :
CISCO-IETF-IP-MIB::cInetNetToMediaPhysAddress : .1.3.6.1.43
SNMP::Info::_load_attr i6_n2p_phys_addr :
IPV6-MIB::ipv6NetToMediaPhysAddress : .1.3.6.1.2.1.55.1.122
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 1217
SNMP::Info::IPv6::ipv6_n2p_mac: data comes from none of the MIBs.
SNMP::Info::_load_attr ip_n2p_phys_addr :
IP-MIB::ipNetToPhysicalPhysAddress : .1.3.6.1.2.1.4.35.1.4
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 1218
SNMP::Info::_load_attr c_inet_phys_addr :
CISCO-IETF-IP-MIB::cInetNetToMediaPhysAddress : .1.3.6.1.43
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 1218
SNMP::Info::_load_attr i6_n2p_phys_addr :
IPV6-MIB::ipv6NetToMediaPhysAddress : .1.3.6.1.2.1.55.1.122
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 1218
SNMP::Info::IPv6::ipv6_n2p_addr: data comes from none of the MIBs.
[10.18.182.2] Processed 0 IPv6 Neighbor Cache entries.
netdisco -D -M 10.18.182.2
n e t d i s c o
--------------------------------------------------
Using Config File : /usr/share/netdisco/netdisco.conf
macsuck(10.18.182.2) :
load_old_devices()
mac_getportmacs() ... found 101612 MACs.
get_device(10.18.182.2)
get_device(10.18.182.2) - Connecting using cached info:
10.18.182.2/e/2 <http://10.18.182.2/e/2>
create_device(10.18.182.2,e,2*,AutoSpecify,bw:default)
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 :
.1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.31
SNMP::Info::device_type() layers:01001110 id:25506 sysDescr:"HPE Comware
Platform Software, Software"
SNMP::Info::specify() - Changed Class to SNMP::Info::Layer3::H3C.
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 :
.1.3.6.1.2.1.1.1.0
[10.18.182.2] Device Type : SNMP::Info::Layer3::H3C
SNMP::Info::_load_attr i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_attr i_description : IF-MIB::ifDescr :
.1.3.6.1.2.1.2.2.1.2
SNMP::Info::_load_attr qb_fw_port : Q-BRIDGE-MIB::dot1qTpFdbPort :
.1.3.6.1.2.1.17.7.1.2.2.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3169
SNMP::Info::_load_attr orig_fw_mac : BRIDGE-MIB::dot1dTpFdbAddress :
.1.3.6.1.2.1.17.4.3.1.1
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3169
SNMP::Info::_load_attr qb_fw_port : Q-BRIDGE-MIB::dot1qTpFdbPort :
.1.3.6.1.2.1.17.7.1.2.2.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3170
SNMP::Info::_load_attr orig_fw_port : BRIDGE-MIB::dot1dTpFdbPort :
.1.3.6.1.2.1.17.4.3.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3170
SNMP::Info::_load_attr bp_index : BRIDGE-MIB::dot1dBasePortIfIndex :
.1.3.6.1.2.1.17.1.4.1.2
SNMP::Info::_load_atrr: BULKWALK Timeout at /usr/sbin/netdisco line 3171
SNMP::Info::_validate_autoload_method(cd11_txrate) Unable to resolve method.
Saw : 0 forwarding table entries. Took 23 seconds.
--- End Message ---
--- Begin Message ---
Thanks Jeroen, I will try that.
What i actually managed to do is set bulk_walk off to true, to use the
GETNEXT process to pull the data out instead of BULKWALK. This worked.. and
I was able to pull data out, i think because went slower to pull out the
data..
Do you recommend using BULKWALK instead and increasing the snmp timeout
Value?
Also on another note, these 5130s in stack mode, are connected to Cisco
ME3600 distribution switches, everything between them has LLDP enabled, but
on netdisco it cant get a mapping correctly from the Cisco.
When i discover the Cisco ME3600, i get these errors
Port for IID:2 not resolved.
Port for IID:26 not resolved.
Port for IID:25 not resolved.
And these are the ports where i have the H3C/Comware switches on.
Is there a issue with Cisco ME3600 mapping to H3C/Comware switches via
LLDP? Does something need to be tweaked to get it working and map it
correctly.
When i look at the 5130, it is able to accurately get the interfaces from
the Cisco via LLDP , however it marks the ports in blue color, which is
blocking. But really it shouldnt be in blue as they are not blocking ports.
Thanks again for your assistance.
--- End Message ---
--- Begin Message ---
Hi Everybody,
Just wondering if anybody can help me out with a custom report in Netdisco
(which is totally awesome Oliver!), I've got so far but I'm a bit stuck as
how to proceed.
I'm trying to generate a list of all the end devices on the network (by ip,
mac and dns), and map that to a switch port and vlan, very similar to the
out of the box device report, but I want to dump a big list joining all of
our network devices together. Hope that makes sense?
The pseudo output would look something like this:
node_ip, node_ip.mac, node_ip.dns, subnet, device, device_ip, device_dns,
device_port.port, device_port.vlan
I can extract the data into each component just I can't work out how to
stick it all together:
Node list which is a tuple of all the data discovered on a scan:
select node_ip
from node_ip
order by node_ip;
Device and IP list:
SELECT device.name,
device.ip,
device.dns
FROM device
ORDER BY device.name;
Device and Port/Vlan list:
SELECT device.name,
device.ip,
device.dns,
device_port.port,
device_port.vlan
FROM device_port
INNER JOIN device ON device.ip=device_port.ip
ORDER BY device.name;
And a simple subnet lookup:
SELECT subnets.nets
FROM subnets
ORDER BY nets
I can live without the subnet part, as I can use a perl module to later
slot the host ip into its subnet but my skill level has reached a ceiling.
Any help is much appreciated.
Regards
Andy Sainsbury
--- End Message ---
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
