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

SQL Filter to exclude a backup device from "Nodes Not UP"

Hi all,

I'm trying to write a SQL Filter to exclude a redundant failover link from "Nodes Not Up" if the primary link is up. Can this be done? If so, can anyone give me a nudge on the syntax for that query?

Find more posts tagged with

sql_2000_filter

Accepted answers

All comments

euphorik

You might need to elaborate a bit on this one...

If I read this correctly, if the primary link is up then the device would NOT appear in the 'Nodes Not Up' (ie. Nodes Down), so there would be nothing to exclude?

Also, if you're showing a summary view for Nodes, I'm not sure you can filter by Interface as they are two different and unrelated things.

What exactly are you trying to accomplish?

FormerMember

I'm not talking about interfaces. I guess I really was too vague, sorry. There are 2 provider routers (nodes). One is primary and one is a backup. The backup is offline when the primary is up. If the primary goes down, the backup is brought online automatically. I don't want the backup to appear offline (down) unless the primary is also down.

It may be a moot point. I've achieved pretty much the same thing by adding "Groups With Problems" to the view and creating a group with the 2 nodes and filtering out warnings on that group so that it only appears in Groups With Problems if both nodes are down.