I need to change the SMTP that is used in all our advanced and basic alerts. Can someone point me to the right place in the database where this entry is stored? I really don't want to change each alert via the gui.
Thanks,
Paul.
Never Mind, I found it.
Would you mind posting your findings and/or SQL update statement? I think this would be pretty handy to have myself.
yes yes, please post... i need to do this on 5 installations
You can try like this:
update AlertActionsset Target=REPLACE(CAST(target as varchar(4000)),'old_name','new_name');
Eric
Hi Paul and others,
Nice question... I have wondered myself a few times how this can be done...
But, in the slipstream of this question, I have the following question to the NPM design team: why is there no global SMTP Server and SMTP Credentials for the alerting engine? Now, we have to enter SMTP Server and Credentials on each of the configured alerts. Would be nice if there was a global SMTP Setting, that (if needed) could be overwritten on the individual alerts themselves. What is the reason for this design decision?
Regards, Rene
Hi Eric,
Thanks for the tip! But where do I execute the script-statement that you mention here?
can someone please send detailed instructions on this. I am using NMP9.5 SP4.
Thanks
Andy
