Finding My Links in the Database

If someone asked you where My Links were stored what you say?

First guess? They are part of My Sites right? I mean that is where you go to manage them and such. Nope. They are actually stored in your profile.

The reason I found out? A couple of my customers did some work around creating a new SSP and moving My Sites. When they got the My Sites moved over to the new location to their displeasure they found My Links missing. So they called me. Long story short I will tell you how to figure out what database they are in and how to read them out.

As always! Modifying a SharePoint Database is NOT SUPPORTED. Some would even argue running this select query against a database is not supported. In a perfect world ok, but sometimes people want info out of the DB not excuses. So don’t shoot the messenger, I am just telling you how to get to it. If you do it or not is up to you.

  1. So the first thing you need to do is figure out what profile database you need information out of. To do that you go to Central Admin.
  2. Now Click Shared Services Administration from the quick launch.
  3. From this screen hover over the appropriate SSP name, click the drop down arrow, and choose Edit Properties.

  4. Now find where it says SSP Database. This your Database Name.
  5. Now you need to open a SQL Query Window using the SQL Management tools
  6. Then run the query below – Remember to replace the Use statement with your database name from step 4

Use SharedServices1_DB








UserLinks UL inner join UserProfile_Full UP on UL.recordId = UP.recordID


  1. You should then get a nice table of your results back.

  2. In the case of Kenny and Dave they will be emailing each user a report of their links so they can set them up again. Not saying you couldn’t find a different way to do this. J That is just the best solution for them.


Special thanks goes out to Kenny T and Dave E for their help with getting this information out there. They have inspired other blog post in the past but this time they actually wrote the SQL query so they get their names up in lights. Thanks guys!


Enjoy Turkey Day!


Shane – SharePoint Help

13 Comments so far

  1. Hi,
    Let me know we can add my links directly through the database.

  2.   Prabhakar on August 26th, 2008          Reply

    Hey, You done a Superb job.

  3.   Mike O on September 26th, 2008          Reply

    I have to rebuild the SSP so this really helps us prepare.

    One suggestion for the script. If you add in the ul.GroupTitle field you can get the Category name for the links. Many of my users organize them.

    Thanks again for posting!

  4.   Jeswin on October 28th, 2008          Reply

    Thanks .It helps me very much

  5.   Jeswin on October 28th, 2008          Reply

    Yar..Its a very good one.Actually am struggling ..Bt this article help me very much.thanks a lot

  6.   Servé Hermans on September 21st, 2009          Reply

    If the reason you are moving My Sites is global deployment to another farm, then consider using the Profile Replication tool that is part of the Diagnostic toolkit released by MS. The replication uses the Trusted my site location to prevent duplicate My Sites across farm. But it is also used to identify your master User Profile. It then synchronizes your profile information to the other farm including the My Links.

  7.   Ayman El-Hattab on September 25th, 2009          Reply

    Five reasons not to directly query SharePoint databases

  8.   ehaze on November 2nd, 2009          Reply

    your pics are not loading…

  9.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  10.   Buy Ambien on February 17th, 2010          Reply

    persuaded hardship before assume sued declare comfort cardboard disseminate probe fulton
    saramartisakis kulturenostro

  11.   rfarqleet on April 15th, 2010          Reply


    I completely agree with all that here is told
    Your blog about Finding my Links in the database helped me a lot.

    thank you! Master

  12.   Ram on July 26th, 2011          Reply

    If you upgraded user profiles from 2007 to 2010 I’m not sure why you would need to do this, each user could simply navigate to MySite Host URL\_layouts\MyQuickLinks.aspx and then convert the links to tags using “Create Tag from Link” option

  13.   Anne Loveless on July 12th, 2012          Reply

    I found the URL to a page the displays the MY Links on your MY SITE.

    http:// (SP site here)

Leave a Reply