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
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 :
SELECT PRJ_OWNER, PRJ_ID, PRJ_NAME, PRJ_DESCRIPT FROM MHGROUP.PROJECTS WHERE TREE_ID = 'PRFID'