Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


How to Push Membership Data in My Profile of SharePoint 2010

By:   |   Read Comments   |   Related Tips: > Sharepoint

Identify and Eliminate SQL Server Performance Monitoring Issues - Free Webcast


In SharePoint 2010, one of the user problems is when a user is a member of a particular site, but when he navigates to My Profile and goes to the Memberships tab, he or she isn't able to view his memberships.


SharePoint 2010 uses a timer job to pull data from the web application's user profile and pushes it into the membership's collection. Usually this job runs on an hourly basis, so the user will not be able to see changes in the My Site’s memberships tab. In this article, we learn how to resolve this issue.

We have created a site called "SPArticles" in which we have added a test user to a site members group. Usually when a user is added to a site members group, they would be able to view his membership in the memberships tab of My Site.

sp articles

Right after adding, the test user's membership data is not yet synchronized.

my site

To synchronize the data, go to Central Administration -> Monitoring -> Timer Jobs and click on Review Job Definitions.

timer jobs

Find a timer job service named "User Profile Service Application - User Profile to SharePoint Full Synchronization" and click on it. Be careful to choose the appropriate service as there might be a custom name to user profile service.

profile service

A screen will appear showing that the timer job service is scheduled to run on an hourly basis. Optionally, we can configure the frequency as needed. In our case, we will click "Run Now" which will trigger the timer job immediately. After clicking, review the job history to check whether the timer job ran successfully or not.

job description

If the timer job runs successfully, within a few minutes, updated membership data will be visible.

Next Steps

Last Update:

next webcast button

next tip button

About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

View all my tips

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 

Send me SQL tips:


Learn more about SQL Server tools