How to Find Favorites and My Matters in iManage Worksite SQL

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'

 

VN:F [1.9.22_1171]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.22_1171]
Rating: +1 (from 1 vote)
How to Find Favorites and My Matters in iManage Worksite SQL, 10.0 out of 10 based on 1 rating

Tags: Duplicates, imanage, My Favorites, My Matters, SQL, worksite

Trackback from your site.