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

Filter Node (SQL) syntax question

Hello Community,

I would like to filter down the vendors displayed In my All Nodes display (shown below) down to only a few vendors. Under the box im not sure what the syntax is to do this for multiple specific vendors. I am able to do it for one vendor by name or vendor by status, but multiple vendors im not sure how. I would like to Filter it down to Cisco, Network Appliance Corporation, VMWare, Palo Alto Networks only. Any ideas on how to accomplish this? Thanks.

Find more posts tagged with

Accepted answers

neomatrix1217

Use an Or statement like (Vendor = 'CIsco' or Vendor = 'Windows')

All comments

neomatrix1217

Use an Or statement like (Vendor = 'CIsco' or Vendor = 'Windows')

njoylif

you can also do Vendor IN ('Cisco','Network Appliance Corporation','VMWare','Palo Alto Networks')

either way should work.

ccraddock

Wow! It does work! Thanks again guys! This community is awesome!