Print this page
Monday, 25 June 2012 22:49

Get All indexed User Profile property

Written by
Rate this item
(1 Vote)

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


Read 9971 times Last modified on Tuesday, 12 January 2016 10:45
Luca Costante

Latest from Luca Costante

Related items