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

Using variables in advanced alert e-mail RECIPIENT field.

Hi there,

We have many sites with servers located at each site. The majority of these are owned by the IT staff at the local site.

I'm going to create a custom property (called "site") and use this filter to determine who receives (via e-mail) the notification - however I was wondering if there is any way to add any programming/variables to the e-mail recipient field? That seems to be one of the very few areas that has to be manually typed in.

Ideally - I'd really like to use a if..then type of condition (If "site"="NYC" then recipient =NYC_IT@fakecompany.com and if
"site"="Toronto" then recipient =Toronto_IT@fakecompany.com , etc) but it looks like this isn't possible.

Otherwise, I believe I'll have to create one alert per site - not a huge deal but it seems like it could be handled more efficiently, especially with a large number of sites.

Does anyone have a suggestion of a way to do this? I know I could use the contact field from the SNMP agents, but none of my systems have this set in the style of an e-mail address and I think it would be almost impossible to update them all.

Thanks

Find more posts tagged with

Accepted answers

All comments

qle

There's [url=]another *somewhat* related thread asking the same question. In that thread, the poster is trying to use data supplied through SNMP to populate the "To:" address of the e-mail alert. In your case, you could create a custom property that stores the e-mail address of target e-mail address. The problem with this is that it could possible make more work for you because you would have to populate both the "site" and "e-mail" fields. On the other hand, you'd only have to create one alert for all of this.

However, I like your idea better 1) since you'd only have to populate the "site" field and 2) if the alert for more than one site needs to go to the same recipient, you would need only one alert for this. For example, if "site = Minneapolis" or "site = St. Paul" then send e-mail to "TwinCities_IT@fakecompany.com"; one alert, two sites.

WINNT

You could run an SQL script to update your new custom properties. If you had to you could schedule using OSQL or SQLCMD.

An SQL statement like this:

update Nodes

SET [OSOwnerEmail]='TwinCities_IT@fakecompany.com',

[OSOwnerPager]='TwinCities_IT_Pager@fakecompany.com',

[OSOwner]='TwinCities IT Support'

FROM Nodes

WHERE ( LOCATION = 'Minneapolis') OR (LOCATION = 'St. Paul')

OswegoSam

I think I'm actually going to end up getting rid of the site custom property, and just use an e-mail address custom property instead...

The only reason I wanted the site, was to build conditional logic to create an e-mail address... I can just skip that step and put the required e-mail address(es) - seperated by commands in the field for multiples, and it should work pretty well.