Recently a user lost their favorites in iManage. This was due to a Preferred Database change. Below was an SQL Query you can run on the iManage database server to check where the users old favorites are and also check for Duplicates

Source code

SELECT PRJ_OWNER, PRJ_ID, PRJ_NAME, SUBTYPE FROM MHGROUP.PROJECTS
 WHERE PRJ_OWNER = 'imanage username' AND SUBTYPE = 'S' 
 OR PRJ_OWNER = 'imanage username' AND SUBTYPE = 'F' 
 ORDER BY PRJ_NAME

This will give you the PRJID for My  Favorites ( F ) and My Matters ( S )

To query the folders for thoose workspaces perform the following  :

Source code

SELECT PRJ_OWNER, PRJ_ID, PRJ_NAME, PRJ_DESCRIPT FROM MHGROUP.PROJECTS WHERE TREE_ID = 'PRFID'