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

Dashboard views filter?

xavierperez

Nodes Not Up

The Following Nodes are not Responding

Code is : Vendor = 'Cisco' = Only show Cisco devices

Code is : I need the code to also show only Cisco routers

DC-edge-router01.ip

DC-edge-router02.ip

I want my Filter Nodes (SQL) to show only above items?

Types below:

	DC-edge-router01.ip
	DC-edge-Switch01.ip
	DC-edge-Steelheads01.ip

Find more posts tagged with

Accepted answers

jorich

If you are lucky enough to have a consistent naming convention for all your routers, you might combine with Caption. vendor = 'Cisco' and caption like '*-rtr-*'. If you have few enough models of routers perhaps SysObjectID. SysObjectID In ('1.3.6.1.4.1.9.1.1861','1.3.6.1.4.1.9.1.669'). A Custom Property would provide for the simplest filter statement to use, but it would have to be applied to all your desired devices...perhaps a hassle if you don't already have an appropriate one.

All comments

jorich

xavierperez

Thank you i will test shortly

xavierperez

Awesomeness

xavierperez

quick question

I need the code to also show only Network category Items only, not Servers or Other?

Code is ?: Show type = 'Network' ??????

jorich

Depending on what you are monitoring you may have to approach this differently. IsServer <> 1 will exclude what SW classifies as a "server." If you are monitoring appliances with a linux-based OS via SNMP they are sometimes classified as servers, however. You can check by this flag quickly for all your systems by selecting them all in Manage Nodes, then using More Actions > Export Custom Properties. Expand the Advanced column and check only "IsServer" box. This is also a quick way I've found to check many of the properties you might want to build a filter on for systems as you can sort/filter the exported csv in Excel and compare properties for all your systems quickly to see what they have in common, or not.

xavierperez

that's practically it as

IsServer = 1

will only show "server" devices

I need the Network equivalent?

IsNetwork = 1

But (IsNetwork) is not actually for network so do you know what is?

jorich

How about NodesData_Category = 1

xavierperez

looks good thanks