Livelink report for Permissions of all Livelink Folders

Muhammad_Tayyab

Hi,

We need to create a report for all livelink folders permissions

Note:
We want to know which users or groups having which permissions on livelink folder.

Any help will be highly appreciated

Best Regards

Tayyab

Narasimha_Rao

Hi Tayyab,

Use the below query. 

SELECT Permissions = CASE Permissions 

WHEN '128' THEN 'No Permissions' 

WHEN '130' THEN 'See' 

WHEN '36995' THEN 'See, See Content'

WHEN '65666' THEN 'See, Modify' 

WHEN '65670' THEN 'See, Modify, Add Items' 

WHEN '102531' THEN 'See, See Content, Modify' 

WHEN '102535' THEN 'See, See Content, Modify, Add Items' 

WHEN '102547' THEN 'See, See Content, Modify, Edit permissions' 

WHEN '102551' THEN 'See, See Content, Modify, Edit permissions, Add Items' 

WHEN '118915' THEN 'See, See Content, Modify, Delete versions' 

WHEN '118919' THEN 'See, See Content, Modify, Add Items, Delete versions' 

WHEN '118923' THEN 'See, See Content, Modify, Delete versions, Delete' 

WHEN '118927' THEN 'See, See Content, Modify, Add Items, Delete versions, Delete' 

WHEN '118931' THEN 'See, See Content, Modify, Edit permissions, Delete versions' 

WHEN '118939' THEN 'See, See Content, Modify, Edit permissions, Delete versions, Delete' 

WHEN '127107' THEN 'See, See Content, Modify, Delete versions, Reserve' 

WHEN '127111' THEN 'See, See Content, Modify, Add Items, Delete versions, Reserve' 

WHEN '127115' THEN 'See, See Content, Modify, Delete versions, Delete, Reserve' 

WHEN '127119' THEN 'See, See Content, Modify, Add Items, Delete versions, Delete, Reserve' 

WHEN '127123' THEN 'See, See Content, Modify, Edit permissions, Delete versions, Reserve' 

WHEN '127131' THEN 'See, See Content, Modify, Edit permissions, Delete versions, Delete, Reserve' 

WHEN '233603' THEN 'See, See Content, Modify, Edit attributes' 

WHEN '233607' THEN 'See, See Content, Modify, Edit attributes, Add Items' 

WHEN '233619' THEN 'See, See Content, Modify, Edit permissions, Edit attributes' 

WHEN '249987' THEN 'See, See Content, Modify, Edit attributes, Delete versions' 

WHEN '249995' THEN 'See, See Content, Modify, Edit attributes, Delete versions, Delete' 

WHEN '258179' THEN 'See, See Content, Modify, Edit attributes, Delete versions, Reserve' 

WHEN '258187' THEN 'See, See Content, Modify, Edit attributes, Delete versions, Delete, Reserve' 

WHEN '16777215' THEN 'Administrator Rights' END 

FROM DtreeACL , Dtree 

WHERE Dtree.DataID = DtreeACL.DataID 

AND Dtree.Subtype=0 AND DtreeACL.DataID = <Folder objID> AND DtreeACL.RightID = 1000

Thanks and Regards,
Narsi
Supai Systems,
Bangalore, India.
e-mail  : narsi@supaisystems.com
website: www.supaisystems.com

On Wed, Feb 1, 2012 at 2:37 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Livelink report for Permissions of all Livelink Folders

Posted bymtayyab@oneecm.com (Tayyab, Muhammad)On 02-01-2012 04:00

Hi, We need to create a report for all livelink folders permissions Note: We want to know which users or groups having which permissions on livelink folder. Any help will be highly appreciated Best Regards Tayyab

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center