--- Begin Message ---
Has anyone figured something out for this?
It was suggested to look at using hooks, but not sure where to take this. I
think it would be a great feature request - being able to search for
specific fields like phone extensions in this case, or other fields from
LLDP (ie AP name - for some reason this one is not showing up in connected
nodes/devices)
TIA.
On Mon, Jan 3, 2022 at 1:49 PM Ricardo Stella <ste...@rider.edu> wrote:
>
> 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 ---
