Open for Voting
over 1 year ago

LLDP inventory collection

Collect LLDP inventory information.

there are three things I'm interested in being collected for inventory purposes:

a) LLDP neighbors

node, interface, remote-chassis-id, remote port, remote SystemName

b) LLPD power discovery

to detect over-committed PoE provisioning on a switch

Parents
  • It has been 5 months since I last asked this question, it seems I am not the only one. Is Solarwinds ever going to step up and support LLDP data collection?

  • Hi,

    The following SQWL code will help you retrieve LLDP information:

    SELECT RemoteSystemName as [System Name],LocalPortNumber as [Local Interface], RemotePortId as [Chassis Id], RemotePortDescription as [Remote Port Info], RemoteIpAddress as [Remote IP Address]

    FROM Orion.NodeLldpEntry

    WHERE NodeID = ${NodeID}

    order by Remotesystemname

    That's what I am using currently.

Comment
  • Hi,

    The following SQWL code will help you retrieve LLDP information:

    SELECT RemoteSystemName as [System Name],LocalPortNumber as [Local Interface], RemotePortId as [Chassis Id], RemotePortDescription as [Remote Port Info], RemoteIpAddress as [Remote IP Address]

    FROM Orion.NodeLldpEntry

    WHERE NodeID = ${NodeID}

    order by Remotesystemname

    That's what I am using currently.

Children