Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
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

Ability to Query Nodes On All Configured Subnets for Network ID?

Hi,

I was hoping to see if anyone knew whether or not it would be possible to query a node (primarily Cisco) for ALL configured subnets/routed interfaces/SVIs and find the NETWORK ID associated with each.

Example:

interface vlan 10: 10.10.10.10/24 would return 10.10.10.0/24

interface Tw1/0/1: 10.0.0.130/25 would return 10.0.0.128/25

So far, I've only been able to find the configured IP on the node within each subnet, and the corresponding mask.

Thanks!

Find more posts tagged with

Accepted answers

All comments

bobmarley

Here is a start. This is a huge query if you don't run it without getting very specific with the Where statement it may run until it times out. I placed a top 10 there to limit the rows returned.

SELECT top 10
     [Nodes].NodeID
    ,[Nodes].Caption AS NodeName
    ,[Nodes].interfaces.InterfaceID
    ,[Nodes].interfaces.InterfaceName
    ,[Nodes].NodeIPAddresses.IPAddress
    ,[Nodes].NodeIPAddresses.SubnetMask
    ,CONCAT([Nodes].NodeIPAddresses.IPAddress, '/', [Nodes].NodeIPAddresses.SubnetMask) AS NetworkID
FROM orion.Nodes

WHERE [Nodes].Vendor = 'Cisco'

k_barton

Thanks. This is nice, but it's just concatenating the configured IP and mask. I'd really like to see if it's there exists a variable or some way to pull back the actual network identifier, like how my original post outlines if we have a configured IP of 10.10.10.0/24, it'd return 10.10.10.0/24