The main reason for confusion around the updating (sync’ing) of My Profile details into team sites is that it is now based on if the user is Active. As part of the upgrade to V3 Microsoft introduced the idea of users being active in a site rather than just having access.

When you first visit a site a record is recorded in the UserInfo table of the sites Content Database. The field tp_IsActive is defaulted to false, which means you have visited but have not interacted with the site.

The Sync process uses this value to determine if the user info should be replicated from the My Profile details as edited above.

Following on from the example above you should be able to refresh your team site that you had only visited and see the user name is still the same, it was not updated when the My Site was updated.

Connect to the SQL Server instance using the correct User ID and Password.

Note: If you are connecting SQL Server form your client then you may need to connect to SQL Server with special account with the correct permissions on the SQL Server. Run the SQL MS with Run as option in that case.

Expand Databases -> Choose to expand the DB in which your Site collection resides.

Expand Tables in that Database -> Right click on dbo.userinfo table.

In the new Query editor, write the query:

FROM [Database name].[dbo].[UserInfo]

with(nolock)

where tp_login like 'User ID’

After running the above query, it will display all the result of the sites on which that user is having the permissions.

You need to find the site against its ID, you can find the site ID using the PS commands.

PS > $mysite = Get-SPSite

PS > $mysite.id

Next steps would be to check if the user is active on the site or not.

You need to find form the result of query the value of the field tp_IsActive is 0, which means users had visited the site in the past but had not interacted with the site much else this value had to be 1.

Steps suggested to user:

Asked user to update their new picture on the mysite. Deleted them from the All Peoples group from the site and Re-added them. After waiting sometime it worked for the user i.e. their pictures were displaying in the SharePoint groups.

Thursday, July 24, 2014

I was working on one of the requirement we have taken to set-up SharePoint 2013 from their existing SharePoint 2010 environment.

While working with client he was saying that they need to bind the all the site collections in there and environment to a single web app in SharePoint 2013 set-up and was mentioning about the Host Names site collections.

I have never heard of this term before.

This is a not a new addition to the SharePoint 2013 family but I was surprised to know that it was there in SharePoint 2010 and I didn't not about it. It is preferable method to use in the host the site collection with different URLs on o Web application.

MS claims that this is the most preferable way to host your site as Office 365 used this method to support multiple clients.

There are different opinions of the different experts with this approach such as some organisation doesn't want to use it because security reasons and some prefer it based on the small scale of your environment.

However, my buy on this is basically a mix of both and I would suggest leave it on customer discretion to how they wanted to have their environment set-up.

Please Share your experiences and thoughts in the comment section to this article.