I need to create a custom report that will give me close to the same as CDP_Neighbor_Resource_v2.SWQL but I need to add the SFP type into the report on each side so that we can identify (most likely) the fiber type utilized. I also need to be able to search by node name so that I can just hit the specific site I'm looking at since we have tens of thousands of nodes and the entire report would take awhile to make.
Best case scenario would be to make a website to query the information and spit out the table in that website utilizing an API and feeding in the site name to the query and then returning the results.
Let me know if that's possible and if so the process.
Thanks!