Which table in applications manager stores email addresses mentioned at the time of User creation ,Notifications and Master Agent update ?

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Which DB table in applications manager stores email addresses mentioned at the time of  

User creation
Notifications
Master Agent

Is it possible to update the email address field using SQL query ?

Environment

CA Automic Applications Manager 9.5  . 

Resolution

Please find the below information related to DB tables. 

User's email -> so_user_table.so_email
Notifications -> aw_notif_detail.aw_notif_email
SMTP EMail -> SO_OPERATOR.EMAIL -> This is XML.

I strongly suggest against directly modifying the data unless you have a full backup and tested the modification in test system.