How to change the subject of the Plesk notification emails?

Plesk Onyx and below

1. Connect to the server using SSH

2. Create a database backup before any updates:

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin psa > /root/psa`date +%F_%H.%M`.sql

3. Check notification subjects:

   # mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -Ne "SELECT id, subj FROM Notifications;"
   +----+------------------------------------------------------------------------------+
   | 1 | Notification of the customer creation. |
   | 2 | Notification of the site creation. |
   | 3 | Notification: Resource usage by subscription has exceeded the allotments. |
   | 6 | Subscription event notification: The subscription term has expired. |
   | 7 | Subscription event notification: The subscription term is about to expire. |
   | 12 | Application Manager Error notification. |
   | 13 | Notification of the reseller creation. |
   | 16 | Notification: Resource limits exceeded by reseller account. |
   | 18 | Notification: Subscription was suspended due to resource overuse. |
   | 20 | Notification: Reseller account has exceeded its limits and was suspended. |
   | 22 | Notification: Resources overuse blocked for reseller account. |
   | 23 | Application Updates. |
   | 24 | Application Updates. |
   | 25 | Application Updates. |
   | 26 | Attempts to exceed outgoing limits for domains, mailboxes and subscriptions. |
   | 27 | Package Update Manager notification |
   | 28 | Notification: Resource usage by subscription has exceeded the allotments |
   +----+------------------------------------------------------------------------------+

4. Update the desired subject (use the id field for selecting desired event notification).

   For example, if you want to change event notification subject for Notification of the customer creation run the following:

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -e"update Notifications set subj='Changed - Notification of the customer creation' where id=1"

   Note: the event notification subject also contains the hostname of the Plesk server, so the subject looks like:

   CONFIG_TEXT: <example.com> Changed - Notification of the customer creation

   Value example.com cannot be changed within notification subject.