Need to retrieve Favorite Reports from Cognos Workspace

[jeeva]

Hi,

Cognos workspace have the option to select the report as Favorite. so when we select the report as favorite, it list out all favorite reports in My Favorite Section.

here my requirement is to create the list report in Report studio to get all favorite reports for each user,which added in My Favorites of workspace. how can i retreive these favorite reports from Workspace.

am assuming everything added in content store database tables. if it is right, which table need to use to fulfill my requirement.
if it is not correct,in which location cognos will save these favorite reports.

please suggest me.

Thanks.