This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

CDP_Neighbor_Resource_v2.SWQL

Add this to your Nodes page as a Custom Query to see the CDP neighbors of the device, with active links to those devices.

CDP_Resource.jpg

There is at least one caveat, and its a bit odd but it somewhat makes sense if you think about the database structure.   The caveat is that the "Local Interface" column will show up as blank if you haven't managed the interfaces (in "List Resources").    This is because the CDP table stores the interface index for the local interface, but stores the interface name for the remote interface.  So, in order to get the local interface name, I have to join in the "interfaces" table and cross reference the ifindex.   If the interface is not in the interfaces table, you get nothing in that column...

If you want this on your site, go to a "Node Details" page that you want it on.   Click on "Customize Page", if you don't have that link, you don't have permission to do this.  Once in there click on the "+" to add a resource to whatever column you wish to have it in.   Make it a "Custom Query" resource type, adjust where you want it positioned in the column and click on "DONE".  When the "Node Details" page reloads, you will have a resource that is titled "Custom Query" and says in it "No query specified.  Click Edit to enter a SWQL query".  Click on the "EDIT" button.

At this point you should be in the "Edit Resource: Custom Query" page.  Change the "Title" to "CDP Neighbors" or whatever you want the title to be.  Leave the subtitle blank and paste the contents of the attached file into the "Custom SWQL Query:" box.  I recommend changing the "Number of Rows Per Page" to something greater, I have it set at 15.

Click "SUBMIT" and you are done, when the page reloads your CDP neighbors should be there!!

CDP_Neighbor_Resource_v2.SWQL
Parents
  • Hi

    Yes adding the vendor and model would be great. Ive used for guide to add a page with CDP and also LLDP neighbours. We have a certain model of phone with a 'feature' that isn't playing well and we need to identify them and turn it off. Having this page is great for our desktop teams but also in the long run to be able to provide a report of where all of these devices live would be great.

    I'm not able to get my head round this so I'm happy with any help whenever you can.

    thanks for replying

Reply
  • Hi

    Yes adding the vendor and model would be great. Ive used for guide to add a page with CDP and also LLDP neighbours. We have a certain model of phone with a 'feature' that isn't playing well and we need to identify them and turn it off. Having this page is great for our desktop teams but also in the long run to be able to provide a report of where all of these devices live would be great.

    I'm not able to get my head round this so I'm happy with any help whenever you can.

    thanks for replying

Children
No Data