Report for Selected routing resource

Question

I'm trying to get a list of all nodes in our environment that have BGP Neighbors selected in the list resources.  I just can't seem to find any way to do this.  I suspect a custom query would be needed but I have yet to figure out SWQL queries.  Doesn't anybody know how to do this?

russbishop · Answer

This is great, but how to I get the node names?  I tried adding Node.Caption to the select query but it breaks

bshopp · Answer

Chatted with Architecture, try this - SELECT TOP 1000 PollerID, PollerType, NetObject, NetObjectType, NetObjectID, Enabled FROM Orion.Pollers WHERE PollerType LIKE '%BGP%'