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
  • Bump... LLDP

    This will be good in addition to;

    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

    Thank You Alphatest404

Comment
  • Bump... LLDP

    This will be good in addition to;

    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

    Thank You Alphatest404

Children
No Data