Manually updating user information in a SharePoint 2013 database

In the case of SharePoint usage, especially Windows authentication, and the user Profile Service is not configured, it often occurs if the user information in the ad is updated (including first name, display name, message, and so on) and the SharePoint side site is not updated.

At this time, we often operate the data for the update operation, production environment recommended backup, test environment also have to look at the UPDATE statement several times.

1, first enter the authorized user group, see our user name, when the ad update, here name or before the name, as follows:

2, the mouse on the name, you can see the URL link address, when we need Listid and Id,listid is a list of user information, ID is the user's userid, such as:

/_layouts/listform.aspx? pagetype=4&listid={01e9cca7-41ee-43a5-96a0-3a91a9e9ce3d}&id=2

3, first enter the database, find your database, if you do not know which database your site collection, it is recommended to go to the CA (Admin center) to view, and then find the UserInfo table, such as:

4, first through the query statement, find the Data ID 2, and then see Tp_login is the login name, Tp_title is the name value, Tp_email is an e-mail address, such as:

We can execute the following update statement, which is updated as follows:

UPDATE [testresult]. [dbo]. [UserInfo] set tp_title='linyu'where tp_id= 2

5, some cases update the UserInfo table, the user information has been updated, but some special circumstances, but also need to update the user information list, it is necessary to update the Alluserdata table, such as:

6, first through a query statement, find we want to update users, such as:

7, the main update of the field is Tp_columnset, we can click to view the XML inside, such as:

8, the implementation of an UPDATE statement, you can update the personal information we need, as follows:

Update [Wss_content_data].[dbo].[Alluserdata] SetTp_columnset='<bit2>1</bit2><bit3>0</bit3><bit4>0</bit4><bit5>1</bit5> <nvarchar1>jianyu Yang</nvarchar1><nvarchar3>domain\jianyu YANG</NVARCHAR3><NVARCHAR4 >[email protected]</nvarchar4><nvarchar13>jianyu</nvarchar13><nvarchar14>yang</ Nvarchar14><nvarchar16>jianyu yang</nvarchar16><nvarchar19>34</nvarchar19>'whereTp_listid='01e9cca7-41ee-43a5-96a0-3a91a9e9ce3d'  andtp_id=2

Summarize

In the use of their own when the need to update user information, and there is no synchronization service, the last resort for it, hereby make a record, easy to modify later, but also want to have the help of people in need.

All right, here we go, rest and rest.

Manually updating user information in a SharePoint 2013 database