nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

custom sql query to filter the "Top XX Errors & Discards This Hour"?

ian105

I am trying to create 2 separate views

One containing all devices that are on the WAN
Other containing all devices that are not on the wan

I wrote the below sql query, and it returns all interfaces that are a member of a node, with the custom property of WAN_Router in the DeviceType column in the nodes table.

select * from interfaces where NodeID in (select NodeID from nodes where DeviceType = 'WAN_Router')

I cannot seem to figure out how to apply this query into the filter interfaces box, I keep getting Custom SQL filter is incorrectly formated.

Are nested statements such as the above not allowed? If not how would I go about filtering the interface list, based on a value in the nodes table

Find more posts tagged with

Accepted answers

sean.martinez

The SQL Filter will need to be:

Nodes.DeviceType = 'WAN_Router'

All comments

sean.martinez

The SQL Filter will need to be:

Nodes.DeviceType = 'WAN_Router'

ian105

Appreciated

tredgrove

Thanks for the tip - One question, How is the Node ID assigned?

by assorted node attributes or is it a SQL function or....?

tks

solarwooky

">sean.martinez how do I get this done for a single node dynamically. I'd like to use the errors and discards resource on a single node basis. I've tried things like Nodes.NodeID = ${NodeID} but this only give a custom sql error on the web interface.

Any clues or ideas?

solarwooky

sean.martinez here is what I did to get around this single node dynamic query issue. I created 3 Advanced SQL reports in Report Writer, 2 of which directly address the challenge but do not resolve the overall inquiry.

I created the reports based on the report from RichardLetts Top 25 Errors This Hour report. Here they are:

If they work for you, just hit that little "Like" button on the side there. And make it better if you have the skill. My SQL skills are limited. I would love to see this for as much as a week or multiday.