Changing all alerts at one time

I have over 100 alerts and my boss has decided that he doesn't like where the emails are coming from.

Is there a way to change a couple variables of all the alerts at one time instead of spending an entire afternoon changing each alert one at a time?

Thanks

Find more posts tagged with

npm

Alerts

Accepted answers

ondrej.salplachta

In this case you can use following SQL statement. Before you execute that, backup please your NetPerfMon database or at least table ActionDefinitions.

Statement change "From E-Mail Account" on email actions from nobody@nobody.com to required name and email.

Change bold text to name and email which you want to use:

UPDATE ActionDefinitions
SET Parameter3 = '"Name which you want to use" <EMailWhichYouWantToUse@domain.com>'
WHERE ActionType = 'EMail' AND Parameter3 LIKE '"Network Performance Monitor" <nobody@nobody.com>'

I hope it will be useful for you.

All comments

ondrej.salplachta

Hello,

please could you describe me what exactly you need to change on all alerts? I think there is way by write specific SQL update which I can write for you - if it will be technically possible.

Is it for all alerts or only for some alerts? In case only for few is there something same (like word in name, ...)?

Thanks.

adamras

Thanks for the reply.

The thing I need to change on all of them the address that shows the alerts are coming from. By default it's nobody@nobody.com and I need to change that.

I hope that is specific enough. Let me know if you need more.

ondrej.salplachta

In this case you can use following SQL statement. Before you execute that, backup please your NetPerfMon database or at least table ActionDefinitions.

Statement change "From E-Mail Account" on email actions from nobody@nobody.com to required name and email.

Change bold text to name and email which you want to use:

I hope it will be useful for you.

adamras

I finally just got a chance to use this and it worked perfectly! Thank you so much.