How to fetch Neighbour devices report for all the Network devices (Firewall, Cisco, Meraki etc..)
Hi @Sivaprasad
I'm not sure there is an easy way to do this but here is a start for a SWQL query that can get you started.
SELECT N1.Caption AS SourceNode ,N2.Caption AS DestinationNode FROM Orion.Nodes as N1 Inner JOIN Orion.TopologyConnections AS T ON N1.NodeID=T.SrcNodeID AND T.SrcType <> 'Orion.ShadowNodes' INNER JOIN Orion.Nodes AS N2 ON T.DestOrionNodeID=N2.NodeID AND T.DestType <> 'Orion.ShadowNodes'
I tried this - looks good but lacks some info from what I'd like to see if I used this. So, I expanded your SELECT section to be:
SELECT N1.Caption AS SourceNode ,T.SrcInterfaceID ,N1.Interfaces.Caption ,N2.Caption AS DestinationNode ,T.DestInterfaceID ,N2.Interfaces.Caption
BUT a warning…if you have a lot of interfaces this will take time and could slow your system. So, as a test, adjust the SELECT to be: SELECT TOP 100
Hi Lofstrand,
Thank you for the response.
Query is running fine, but having few doubts in the above query, i could not see any DestOrionNodeID column in the Topology Connections table in the database. How this query got running fine ?? and also, i am getting "caption" and "caption1" instead of SourceNode and DestinationNodeID columns names in the output. Please find the below screenshot.
Can we get the same for firewalls also which are all connected to FMCs?
This is not SQL, but SWQL. You might not find the same names in SWQL as you see in your database. Can also be that they are visible in views in SQL, not tables.
The query works for all nodes that solarwinds has topology data on.
