KB10612: How is the Root Profile folder obtained for a user in MicroStrategy

Administrators can run the following SQL queries to obtain the ID of the Root Profile folder for a given user:

• Obtain the ID for the project. This can be done by right-clicking the project and selecting "Project Configuration" in Strategy Developer or running the following SQL:
  Select Object_ID from DSSMDOBJINFO where object_Name = 'Name of the project' and Object_Type = 32
  

• Obtain the Object_ID of the user by right-clicking on the user in Strategy Developer and selecting Properties or running the following SQL:
  Select Object_ID from DSSMDOBJINFO where object_Name = 'Name of the user' and Object_Type = 34
  

• Locate the GUI of the Profile Link collection in the metadata by running the following SQL:
  Select Object_ID from DSSMDOBJINFO where
  Object_Name = 'Profile Link',
  Project_ID = 'Project GUI obtained in step #1',
  Object_Type = 52
  
• Locate the Link item used to link the user to his profile folders:
  Select LinkItem_ID from DSSMDLNKITEM
  where Project_ID = 'Project ID from step #1',
  Object_ID = 'User GUID from step#2',
  Link_ID = 'GUID from Step #3'
  
• Obtain the GUID of the user's root profile folder by running the following SQL:
  Select Prop_val from DSSMDLNKPROP where Val_SEQ = 1 and LinkItem_ID = 'GUID from step 4'