nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
- SolarWinds Academy
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

How to fetch Neighbour devices report for all the Network devices in solarwinds

Sivaprasad

How to fetch Neighbour devices report for all the Network devices (Firewall, Cisco, Meraki etc..)

Find more posts tagged with

network_management

npm

ncm

report

Comments

Lofstrand

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.

Sivaprasad

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?

stuartd

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

Lofstrand

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'

Quick Links

PALO-ALG - Logging
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022
Alert HTML Content
Alert Cleared.htmlHello, I would like to share the HTML template details we have prepared so that Solarwinds alarms can become more meaningful. It can list alarm object details and connected device details separately in HTML template. Except for object and device details, you can easily add custom property information…
Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…