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

Wildcards in Filter Fields

I'm trying to use a wildcard in the Filter Results filed in the Report Writer, but I'm getting no results. I have a condition that states "Records where "System Name" is equal to "R*". I would like only our Routers that have a system name that begins with R to be in the report.

I looked in the book and didn't see any info on this.

Thoughts?

Thanks

Find more posts tagged with

Accepted answers

All comments

iunderwo

Wildcards are not applicable in SQL. You should change the condition to "Records where 'system name' starts with 'R'".

// Ian Underwood - Service Management
// Level 3 Communications

bleearg13

Could you not just use:

System_Name LIKE 'R%'

evt

iunderwo

That's true...and would probably work if you're writing an advanced SQL query. Otherwise "start with" will be faster to run...or at least that's what my experience has shown.

// Ian Underwood - Service Management
// Level 3 Communications