Mass Update of "From" Address and "From Alias" in Archer Notification Templates

[KB-Sync1]

Article Number

000039507

Applies To

Product(s): Archer
Version(s): All Versions
Primary Deployment: On Premises/AWS SaaS

---

Description

Situations, where you may need to update the 'From Address' and 'From Alias' in the notification templates for the Subscription, and Scheduled Report Distribution Notifications, include:

• A large number of existing notification templates need to change the 'From Address' and 'From Alias' for existing notification templates. 
• The decision was made to update the 'From Address' and 'From Alias' for the newly created notification templates.

Resolution

Option 1, use UI
This option can be used if you have decided to change the 'From Address' and 'From Alias' for existing notification templates. To perform this you can change the location of Default "From Address" and "From Alias" under the Global Notification Settings:

1. Login to Archer UI > Administration > Notifications > Global Notification Settings
2. Select the Notification that needs to be changed
3. Change the "From Address" and "From Alias"
4. Click SAVE or SAVE AND CLOSE

0EMVM000006t28z.png
Option 2, use SQL
This option can be used to change existing notification templates. In the Database, the table tblNotificationTemplate table contains information such as Notification Template ID, Template Name, Template description, From Address, From Alias…, etc. 

Note:
Please take back your instance Database before you run the SQL update command.

1. Below SQL query can be used to find out the Template Name, Notification Template ID, From Address, From Alias from all Subscription, XML, and Scheduled Report Distribution Notifications:

select template_name
      ,notification_template_id
      ,from_address
      ,from_alias
from tblNotificationTemplate

2. Once you identify the desired Notification Templates ID(s) from step 1, replace the ### with the ID, from_address and from_alias values in the script below

update tblNotificationTemplate
set from_address = 'ChangeToYourAddress@abc.com'
   ,from_alias = 'ChangeToYourAlias'
where notification_template_id = ###

Note:
If you have multiple templates that use the same from_address and from_alias values, change the WHERE clause from "=" to "in" and place all IDs that use those values within the parentheses.

where notification_template_id in (###, ###, ###)

3. Run the edited SQL update command to update the from_address and from_alias values.