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
I would have thought this was a basic requirement of a network product to simply show the interconnections between network devices at layer two, simply sticking to Cisco CDP is very narrow minded.
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…