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

Alert Variable Manipulation

If an alert variable value like ${N=SwisEntity;M=ComponentAlert.ComponentName} results in "Service: myService" and there is no other variable that returns just "myService" is there anything in the "format output value" option I can use to only return "myService". Some Regex or Trim or something?

Find more posts tagged with

Accepted answers

All comments

mesverrum

You could just rename the component directly, but for people who want to get into the weeds there is a custom sql variable, i've done a lot of text manipulation within those, could be as easy as select top 1 replace('${N=SwisEntity;M=ComponentAlert.ComponentName}','Service: ','')

jameslindsay

Can't really rename the component because the alert traps on the component where name starts with "Service:". I've had poor result using SQL. From time to time the query can take longer then the alert wants to wait and so you end up with no value. I maybe looking at a feature request.