1 of 1 people found this helpful
AFAICS LLDP-MED itself is not gathered automatically, only LLDP state.
if you need LDDP-MED then you'll have to define a custom poller to pull that data and then use the custom poller tables.
for LLDP the SWQL is something like:
SELECT NodeID, LocalPortNumber, RemoteIfIndex, RemotePortId, RemotePortDescription, RemoteSystemName, RemoteIpAddress, DisplayName, Description
where remotesystemname like 'AV%'
[our (~5000) Avaya VOIP phones identify themselves as 'AV%' devices]
if you want the nodes then something like:
SELECT N1.NodeID, N1.Caption, N1.URI
FROM Orion.Nodes N1
where N1.Nodeid in (select NODEID from Orion.NodeLldpEntry L1
where remotesystemname like 'AV%')
[NOTE: this assumes your switches consume LLDP; I have some switches that do not, with the result some phones appear directly connected to the routers.]
Sadly NCM doesn't support gathering LLDP information.
The report that I ended up with in the end was this
SELECT n.sysname, LocalPortNumber, RemoteSystemName, RemotePortId as MAC, RemoteIpAddress, l.nodeid
FROM NodeLldpEntries l, nodes N
where RemoteSystemName like 'LG-E%' and l.nodeid = n.nodeid
order by sysname, localportnumber
Lists all LG-Ericsson IPECS VoIP phones, which switch and port they are on.