Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Users email

  Asked By: Anushka    Date: Oct 23    Category: Sharepoint    Views: 895

Any idea where the system stores the users email address? There is a
table called UserPofile_Full with an email field, but it is null for
everyone, but I know email addresses are being stored somewhere!



4 Answers Found

Answer #1    Answered By: Breann Beach     Answered On: Oct 23

Typical! Found it in UserProfileValue.

Answer #2    Answered By: Vinay Thakur     Answered On: Oct 23

See tp_Email in the UserInfo table.

There is one record for each user per site collection in this table.

Answer #3    Answered By: Ian Powell     Answered On: Oct 23

Hello, just to piggy back on to this does anyone know which field  in the
UserInfo table would identify the Administrator of a site.
Need to associate the admin of the sites with their email  addresses.

Answer #4    Answered By: Osvaldo Winters     Answered On: Oct 23

That information is tp_Email in the UserInfo table. A couple of notes, all the
database schemas are laid out in the WSS SDK. That's a free download from
Microsoft. Searching for "download WSS SDK" in your favorite search engine
should point to the download. Second, you'll get a lot of people warning you
about poking around in SQL. I would never, ever recommend writing to SQL, and I
would caution against reading from it. You can inadvertantly lock tables with
long reads.

Finally, all the user information is available via the Sharepoint Object Model.
It would be trivial to write something up in C# to get this information.

Didn't find what you were looking for? Find more on Users email Or get search suggestion and latest updates.