--- Begin Message ---
I've asked before back in March on how to get phone extensions via LLDP but
it seems that you would need discover_phones enabled, and iour phones do
not have SNMP enabled.
In any case, the information is getting pulled as part of the "remote_type"
- Is there a way to map the contents (and ideally a substring) into a
custom field that can be displayed and/or searched for?
Doing a discover -DIQ you can see remote_type includes the necessary
information: "reqDN 1177" whereas 1177 is the phone's extension. If we can
do this, we could map the model number of the phone as well "MINET_6920"
whereas 6920 is the model.
[17616] 2022-01-03 18:27:52 debug [10.1.1.118] neigh - 10.10.7.142 with ID
[10.10.7.142] on GigabitEthernet1/0/13
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.10.7.142' AND me.ip = '10.10.7.142'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '10.10.7.142'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact,
me.name, me.location, me.layers, me.num_ports, me.mac, me.serial,
me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status,
me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log,
me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain,
me.last_discover, me.last_macsuck, me.last_arpnip, to_char( me.creation,
'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ),
to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char(
me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp
'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.10.7.142'
[17616] 2022-01-03 18:27:52 debug is_discoverable: 10.10.7.142 matches
phone_platforms but discover_phones is not enabled
[17616] 2022-01-03 18:27:52 debug [10.1.1.118] neigh - skip: 10.10.7.142
of type [regDN 1177,MINET_6920,ver: 01.05.03.027,PxE: 6.5,03/01/2022
13:27:23 +0000] excluded by discover_* config
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = '10.10.7.142',
remote_ip = '10.10.7.142', remote_port = 'LAN port', remote_type = 'regDN
1177,MINET_6920,ver: 01.05.03.027,PxE: 6.5,03/01/2022 13:27:23 +0000'
WHERE ip = '10.1.1.118' AND port = 'GigabitEthernet1/0/13'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type,
me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac,
me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id,
me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid,
me.lastchange
FROM device_port me
WHERE me.ip = '10.1.1.118' AND me.port = 'GigabitEthernet1/0/13'
Thanks in advance - Ricardo.
--
°(((=((===°°°(((================================================
--- End Message ---
