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

How do I filter a group on "nodes not up" resource table on solarwinds??

It's easy to make a table showing all the nodes that aren't up, but I would like a table that shows all the devices that are down in a single group, not all groups. Anyone know what the correct sql filter is for that? My group name is NETWORKING.

Find more posts tagged with

Accepted answers

All comments

aLTeReGo

Groups can contain virtually any object type. If you're trying to filter solely based on Node, then I would recommend using Custom Properties instead.

chetz

you can create custom property like NetworkGroup and populate the value as "NETWORKING" on all the nodes that comes under networking.

use the resource and add the below query in the filter nodes (SQL):

NetworkGroup = 'NETWORKING' AND Status=2

let me know if this helps.

silverbacksays

Chethan MN gave a good example. You could also simply add the 'Groups With Problems' or 'Nodes With Problems' built in resources to your views, which will show you only the nodes/groups which have issues.