Blogger

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

    Recent items

Login

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 9426 times Last modified on Tuesday, 12 January 2016 10:45

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.