• This email address is being protected from spambots. You need JavaScript enabled to view it.

    Recent items


Monday, 25 June 2012 22:49

Get All indexed User Profile property

A simple way to know all indexed User Profile property is to query the content DB.

In my case, I need to know for each subtypes, the indexed Property.

To know this information, open the SQL Manager and execute the following query:

Show/Hidden sql code

View source
SELECT TOP 1000 subtypename.ProfileDisplayName, property.PropertyName
  FROM [UserProfile].[dbo].[ProfileSubtypePropertyAttributes] AS subtype 
  JOIN [UserProfile].dbo.[ProfileSubtypeList] AS subtypename  ON  subtype.ProfileSubtypeID = subtypename.ProfileSubtypeID
  JOIN UserProfile].[dbo].[PropertyList] AS property ON subtype.PropertyID = property.PropertyID
  ORDER BY subtypename.ProfileDisplayName


Published in SharePoint