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
Store

Need a report that tell me what devices are not monitoring a specific interface.

I was told we have devices that are not monitoring a specific interface. I was wondering how I would put together a report to show me that information.

Find more posts tagged with

Accepted answers

All comments

Seashore

That specific interface, is it a interface type or interfaces with something in it's name? Should we also only include devices from a specific vendor?

SolarWindNoob

The node are SDW and the interface with something in its name.

SolarWindNoob

Thank you, I will give this a try!

Seashore

I Think this one will do it. As an example will it look for all "cisco" devices that don't have an interface monitored called something like "loopback"

SELECT
N.Caption
,N.NodeID
,N.DetailsUrl

FROM Orion.Nodes AS N
LEFT OUTER JOIN Orion.NPM.Interfaces AS I ON N.NodeID=I.NodeID AND I.Caption LIKE '%Loopback%'
WHERE
I.InterfaceID IS NULL
AND N.Vendor='Cisco'

Change the values to what you are after and try it out in a report. Hope it helps