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

Add text to all existing email alerts?

Is there any way within NPM to add a string to all emails that are already defined? Or am I looking at some mucking around with SQL?

Almost none of the hundreds of existing emails we have set up tell the recipient what event is actually causing the email to be sent. I'd like to add that to every email.

I'm not so good with SQL, but if it comes to that, would be something along the lines of

update [Solarwinds].[dbo].[ActionsProperties]set PropertyValue = PropertyValue + 'email sent by alert named: ${N=Alerting;M=AlertName}'where PropertyName = 'emailmessage' and PropertyValue not like '%${N=Alerting;M=AlertName}%'

Find more posts tagged with

sql

mass_ch

Accepted answers

All comments

jaybone

Sooooo, no way to do this, then?

john.ta

You would be unable to do this within NPM and would need to muck around with SQL.