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

Problem with All Nodes filter

I added an All Nodes resource to my summary view with the following filter:

---
InterfaceName Like 'eth1*' AND Status = 2
---

I receive this error:
Bad Filter Specified: InterfaceName Like 'eth1%' AND Status = 2
Invalid column name 'InterfaceName'.

The "Show List of Interface Properties" is where I obtained the 'InterfaceName' variable.

Find more posts tagged with

all_nodes

Accepted answers

All comments

chris.schear

Instead of an "All Nodes" resource, I added a "Down Interfaces" resource, same filter. THIS is that error:

Bad Filter Specified: InterfaceName Like 'eth1%' AND Status = 2
Ambiguous column name 'Status'.

You may need distinguish which property by adding "Nodes.", "Interfaces.", or "Volumes." at the beginning.

For example : Interfaces.Status = 1 OR Nodes.Status=1

qle

In your first message, the message is essentially saying that the "InterfaceName" column doesn't exist in the Nodes table, which is correct.
In your second message, try this:

InterfaceName Like 'eth1%' AND Interfaces.Status = 2

Hope it works for you.