Trying to find which table the email address is present.
Presently I’m manually creating a user and entering the email address. Im moving to use a SSIS package and unfortunately I couldn’t find the table in which the email address field related to user creation page is located
Hi
sorry for the delay answering, I missed your post somehow.
There is a table handling the relationship between people and their email addresses called
email_addr_bean_rel
In there, the “columns bean_id” and “bean_module” specify the entity that has an email address. For example, if “bean_module” is “Users”, you can use bean_id to look the user up in the “users” table (other possible entities are Contacts, Leads, etc.).
Then there is a column called “email_address_id” which is a reference to the “id” column in table “email_addresses”.