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

Interface UP Resource

Hello, I am trying to setup a resource that similar to interfaces down but shows interfaces that are UP. How can I display all nodes where Tunnel7 is UP instead of down? Thanks!

Find more posts tagged with

Accepted answers

janene16

Use the All Interfaces resource and add this SQL filter to just show ALL tunnel7 Interfaces that are UP:

Interfaces.Status = 1 and Interfaces.Interfacename Like '*Tunnel7*'

All comments

janene16

Use the All Interfaces resource and add this SQL filter to just show ALL tunnel7 Interfaces that are UP:

Interfaces.Status = 1 and Interfaces.Interfacename Like '*Tunnel7*'

john.ta

Although I'd like it without the percent utilization, that works!

However I do wish to exclude some nodes and am having difficulty using LIKE and NOT LIKE in same query:

Interfaces.Status = 1 AND Interfaces.Interfacename LIKE '*Tunnel7*' AND Caption NOT LIKE '*MAIN-ROUTER*'

How can I exclude some nodes?

janene16

what version is your NPM?

janene16

If you're on Orion 2015.1.x, you can use nodesdata.caption not like

But if you're on older version of Orion, you can use nodes.caption not like

john.ta

I am running 11.5 and nodesdata.caption works, thanks so much!