Report to see who has permissions to an Object (Folder) within Livelink

Mary_Henschel_(tripro01consult_-_(deleted))

We would like to run a report to see which individuals have been given permissions to a particular folder. We assign permissions via groups to folders, so it is not obvious which individuals have access. Thanks.

Find more posts tagged with

Comments

Steve_McDonough

We use the attached report. If you are running MS SQL, you might be able to import it and customize it to your exact requirements.Hope that it helps,Leon

David_Kim_(seamon01admin_-_(deleted))

Message from David Kim via eLinkI get a Server Did Not Respond when I try importing this.Thanks,David-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Thursday, February 10, 2005 11:01 AMTo: eLink RecipientSubject: RE Report to see who has permissions to an Object (Folder)within LivelinkRE Report to see who has permissions to an Object (Folder) withinLivelink Posted by Kish, Leon on 02/10/2005 01:59 PMWe use the attached report. If you are running MS SQL, you might be ableto import it and customize it to your exact requirements.Hope that it helps,Leon[To reply to this thread, use your normal E-mail reply function.]============================================================Attachment link: Folder_Permissions.rpthttps://knowledge.opentext.com/knowledge/livelink.exe/3841376/Folder_Permissions.rpt?func=doc.Fetch&nodeid=3841376============================================================Topic: Report to see who has permissions to an Object (Folder)within Livelinkhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3843113&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe

Mary_Henschel_(tripro01consult_-_(deleted))

Thanks - we will give it a shot and let you know how it goes.

Steve_McDonough

Hello David,I'm not sure why that is but if you want to build it as a new LiveReport here goes:Title: Permissions on a Given FolderInputs: Type: Container Prompt: Enter FolderSQL (cut it and paste it obviously):SELECT DTREEACL.DATAID "Object ID", CASE DTree.SubType WHEN 0 THEN 'Folder' WHEN 1 THEN 'Alias' WHEN 2 THEN 'Generation' WHEN 128 THEN 'Workflow Map' WHEN 130 THEN 'Topic' WHEN 131 THEN 'Category' WHEN 132 THEN 'Category Folder' WHEN 133 THEN 'Categories Volume' WHEN 134 THEN 'Reply' WHEN 136 THEN 'Compound Document' WHEN 137 THEN 'Release Volume' WHEN 138 THEN 'Release' WHEN 139 THEN 'Revision' WHEN 140 THEN 'URL' WHEN 141 THEN 'Enterprise Workspace' WHEN 142 THEN 'Personal Workspace' WHEN 143 THEN 'Discussion Volume' WHEN 144 THEN 'Document' WHEN 145 THEN 'Text Document' WHEN 148 THEN 'System Volume' WHEN 150 THEN 'Livelink' WHEN 153 THEN 'Workflow Step' WHEN 154 THEN 'Workflow Attachments' WHEN 161 THEN 'Workflow Volume' WHEN 162 THEN 'Workflows Edit Volume' WHEN 180 THEN 'Domain Workspace' WHEN 188 THEN 'Workflow Status' WHEN 189 THEN 'Workflow' WHEN 198 THEN 'Classifications' WHEN 201 THEN 'Project Workspace' WHEN 202 THEN 'Project' WHEN 204 THEN 'Task List' WHEN 205 THEN 'Task Group' WHEN 206 THEN 'Task' WHEN 207 THEN 'Channel' WHEN 208 THEN 'News' WHEN 209 THEN 'Channel Volume' WHEN 210 THEN 'Task List Volume' WHEN 211 THEN 'Reports Volume' WHEN 212 THEN 'Milestone' WHEN 215 THEN 'Discussion' WHEN 218 THEN 'Poll' WHEN 223 THEN 'Form' WHEN 226 THEN 'HTML View' WHEN 230 THEN 'Form Template' WHEN 231 THEN 'Submit Version' WHEN 257 THEN 'Livelink Search Engine' WHEN 258 THEN 'Query' WHEN 259 THEN 'Enterprise Extractor' WHEN 260 THEN 'Proxy' WHEN 268 THEN 'Template Folder' WHEN 269 THEN 'Search Manager' WHEN 270 THEN 'Data Flow Manager' WHEN 271 THEN 'Process' WHEN 272 THEN 'Enterprise Search Engine' WHEN 275 THEN 'Slice Folder' WHEN 276 THEN 'Data Source Folder' WHEN 277 THEN 'Directory Walker' WHEN 278 THEN 'Search Result Snapshot' WHEN 280 THEN 'Spider' WHEN 281 THEN 'Index Engine' WHEN 282 THEN 'HTML Conversion' WHEN 285 THEN 'XML Activator Producer' WHEN 286 THEN 'XML Activator Consumer' WHEN 287 THEN 'XML Activator Intermediate' WHEN 288 THEN 'XML Activator Filter' WHEN 289 THEN 'XML Activator' WHEN 290 THEN 'Backup Manager' WHEN 291 THEN 'Backup Process' WHEN 292 THEN 'Search Template' WHEN 293 THEN 'Enterprise Importer' WHEN 294 THEN '2 Way Tee' WHEN 299 THEN 'LiveReport' WHEN 301 THEN 'Personal Workspace' WHEN 302 THEN 'Projects' WHEN 303 THEN 'News' WHEN 304 THEN 'Reports' WHEN 305 THEN 'Assignments' WHEN 306 THEN 'Favorites' WHEN 307 THEN 'Queries' WHEN 308 THEN 'Snapshots' WHEN 309 THEN 'LiveReports' WHEN 335 THEN 'XML DTD' WHEN 336 THEN 'XML DTD Volume' WHEN 385 THEN 'Prospector' WHEN 387 THEN 'Prospector Snapshot' WHEN 391 THEN 'Collector' WHEN 392 THEN 'Collector Folder' WHEN 400 THEN 'External Project' WHEN 401 THEN 'Installation' WHEN 402 THEN 'Deleted Documents Volume' WHEN 410 THEN 'Livelink Physical Object Module' WHEN 411 THEN 'Livelink Physical Object Module' WHEN 412 THEN 'Livelink Physical Object Module' WHEN 550 THEN 'Records Management' WHEN 552 THEN 'Hold Maintenance' WHEN 553 THEN 'RSI' WHEN 554 THEN 'Disposition' WHEN 556 THEN 'Table Maintenance' WHEN 666 THEN 'MeetingZone Meeting Room' WHEN 120374 THEN 'Appearance HTML' ELSE 'Unknown' END "Object Type", DTree_1.Name AS [Object Location],DTree.Name AS [Object Name], CASE DTREE.CATALOG WHEN 0 THEN 'List' WHEN 1 THEN 'Catalog' WHEN 2 THEN 'Hidden' END 'Object Display Type', CASE DTREEACL.RIGHTID WHEN '-1' THEN 'Public Access' WHEN '-2' THEN 'System Administrators' ELSE 'User ID: ' + STR(DTREEACL.RIGHTID) END [Privileges Assigned To], CASE DTreeACL.Permissions WHEN 128 THEN 'No Rights' WHEN 130 THEN 'S' WHEN 36995 THEN 'S/SC' WHEN 36999 THEN 'S/SC/AI' WHEN 62666 THEN 'S/M' WHEN 65670 THEN 'S/M/AI' WHEN 102531 THEN 'S/SC/M' WHEN 102535 THEN 'S/SC/M/AI' WHEN 102547 THEN 'S/SC/M/EP' WHEN 102551 THEN 'S/SC/M/EP/AI' WHEN 118915 THEN 'S/SC/M/DV' WHEN 118919 THEN 'S/SC/M/AI/DV' WHEN 118923 THEN 'S/SC/M/DV/D' WHEN 118927 THEN 'S/SC/M/AI/DV/D' WHEN 118931 THEN 'S/SC/M/EP/DV' WHEN 118939 THEN 'S/SC/M/EP/DV/D' WHEN 118935 THEN 'S/SC/M/EP/AI/DV' WHEN 118943 THEN 'S/SC/M/DP/AI/DV/D' WHEN 127107 THEN 'S/SC/M/DV/R' WHEN 127111 THEN 'S/SC/M/AI/DV/R' WHEN 127115 THEN 'S/SC/M/DV/D/R' WHEN 127119 THEN 'S/SC/M/AI/DV/D/R' WHEN 127123 THEN 'S/SC/M/EP/DV/R' WHEN 127127 THEN 'S/SC/M/EP/AI/DV/R' WHEN 127131 THEN 'S/SC/M/EP/DV/D/R' WHEN 127135 THEN 'S/SC/M/EP/AI/DV/D/R' WHEN 233603 THEN 'S/SC/M/EA' WHEN 233607 THEN 'S/SC/M/EA/AI' WHEN 233619 THEN 'S/SC/M/EP/EA' WHEN 233623 THEN 'S/SC/M/EP/EA/AI' WHEN 249987 THEN 'S/SC/M/EA/DV' WHEN 249991 THEN 'S/SC/M/EA/AI/DV' WHEN 249995 THEN 'S/SC/M/EA/DV/D' WHEN 249999 THEN 'S/SC/M/EA/AI/DV/D' WHEN 250003 THEN 'S/SC/M/EP/EA/DV' WHEN 250007 THEN 'S/SC/M/EP/EA/AI/DV' WHEN 250011 THEN 'S/SC/M/EP/EA/DV/D' WHEN 250015 THEN 'S/SC/M/EP/EA/AI/DV/D' WHEN 258179 THEN 'S/SC/M/EA/DV/R' WHEN 258183 THEN 'S/SC/M/EA/AI/DV/R' WHEN 258187 THEN 'S/SC/M/EA/DV/D/R' WHEN 258191 THEN 'S/SC/M/EA/AI/DV/D/R' WHEN 258195 THEN 'S/SC/M/EP/EA/DV/R' WHEN 258199 THEN 'S/SC/M/EP/EA/AI/DV/R' WHEN 258203 THEN 'S/SC/M/EP/EA/DV/D/R' WHEN 258207 THEN 'Full Permissions' WHEN 16777215 THEN 'Admin' ELSE 'New: ' + STR(DTreeACL.Permissions) END Permissions, KUAF.FirstName + ' ' + KUAF.LastName as [User Name], KUAF.Name "Group Name/Login" FROM DTreeACL INNER JOIN DTree ON DTreeACL.DataID = DTree.DataID INNER JOIN KUAF ON DTreeACL.RightID = KUAF.ID INNER JOIN DTree DTree_1 ON DTree.ParentID = DTree_1.DataID WHERE (DTreeACL.ACLType = 0) AND (DTreeACL.ParentID <> - 1) AND (DTreeACL.Permissions <> 128) and kuaf.deleted=0 and DTree.ParentID = %1 AND %2 ORDER BY DTree_1.Name, DTree.NameParam %1: User Input 1Param %2: Filter PermissionsMake it an 'Auto LiveReport' and you can 'Configure' to allow 100% width and columns to wrap.Good luck,Leon

David_Kim_(seamon01admin_-_(deleted))

Message from David Kim <dkim@Elevated.org> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">Message

Thanks. I created a new report and this is the syntax error I get:

Livelink Error: Report
[Line 1: Incorrect syntax near 'TH'. - SELECT DTREEACL.DATAID "Object ID", CASE DTree.SubType WHEN 0 THEN 'Folder' WHEN 1 THEN 'Alias' WHEN 2 THEN 'Generation' WHEN 128 THEN 'Workflow Map' WHEN 130 THEN 'Topic' WHEN 131 THEN 'Category' WHEN 132 THEN 'Category Folder' WHEN 133 THEN 'Categories Volume' WHEN 134 THEN 'Reply' WHEN 136 THEN 'Compound Document' WHEN 137 THEN 'Release Volume' WHEN 138 THEN 'Release' WHEN 139 THEN 'Revision' WHEN 140 THEN 'URL' WHEN 141 THEN 'Enterprise Workspace' WHEN 142 THEN 'Personal Workspace' WHEN 143 THEN 'Discussion Volume' WHEN 144 THEN 'Document' WHEN 145 THEN 'Text Document' WHEN 148 THEN 'System Volume' WHEN 150 THEN 'Livelink' WHEN 153 THEN 'Workflow Step' WHEN 154 THEN 'Workflow Attachments' WHEN 161 THEN 'Workflow Volume' WHEN 162 THEN 'Workflows Edit Volume' WHEN 180 THEN 'Domain Workspace' WHEN 188 THEN 'Workflow Status' WHEN 189 THEN 'Workflow' WHEN 198 THEN 'Classifications' WHEN 201 THEN 'Project Workspace' WHEN 202 THEN 'Project' WHEN 204 THEN 'Task List' WHEN 205 TH! EN 'Task Group' WHEN 206 THEN 'Task' WHEN 207 THEN 'Channel' WHEN 208 THEN 'News' WHEN 209 THEN 'Channel Volume' WHEN 210 THEN 'Task List Volume' WHEN 211 THEN 'Reports Volume' WHEN 212 THEN 'Milestone' WHEN 215 THEN 'Discussion' WHEN 218 THEN 'Poll' WHEN 223 THEN 'Form' WHEN 226 THEN 'HTML View' WHEN 230 THEN 'Form Template' WHEN 231 THEN 'Submit Version' WHEN 257 THEN 'Livelink Search Engine' WHEN 258 THEN 'Query' WHEN 259 THEN 'Enterprise Extractor' WHEN 260 THEN 'Proxy' WHEN 268 THEN 'Template Folder' WHEN 269 THEN 'Search Manager' WHEN 270 THEN 'Data Flow Manager' WHEN 271 THEN 'Process' WHEN 272 THEN 'Enterprise Search Engine' WHEN 275 THEN 'Slice Folder' WHEN 276 THEN 'Data Source Folder' WHEN 277 THEN 'Directory Walker' WHEN 278 THEN 'Search Result Snapshot' WHEN 280 THEN 'Spider' WHEN 281 THEN 'Index Engine' WHEN 282 THEN 'HTML Conversion' WHEN 285 THEN 'XML Activator Producer' WHEN 286 THEN 'XML Activator Consumer' WHEN 287 THEN 'XML Activator Intermediate' WHEN 28! 8 THEN 'XML Activator Filter' WHEN 289 THEN 'XML Activator' W! HEN 290 THEN 'Backup Manager' WHEN 291 THEN 'Backup Process' WHEN 292 THEN 'Search Template' WHEN 293 THEN 'Enterprise Importer' WHEN 294 THEN '2 Way Tee' WHEN 299 THEN 'LiveReport' WHEN 301 THEN 'Personal Workspace' WHEN 302 THEN 'Projects' WHEN 303 THEN 'News' WHEN 304 THEN 'Reports' WHEN 305 THEN 'Assignments' WHEN 306 THEN 'Favorites' WHEN 307 THEN 'Queries' WHEN 308 THEN 'Snapshots' WHEN 309 THEN 'LiveReports' WHEN 335 THEN 'XML DTD' WHEN 336 THEN 'XML DTD Volume' WHEN 385 THEN 'Prospector' WHEN 387 THEN 'Prospector Snapshot' WHEN 391 THEN 'Collector' WHEN 392 THEN 'Collector Folder' WHEN 400 THEN 'External Project' WHEN 401 THEN 'Installation' WHEN 402 THEN 'Deleted Documents Volume' WHEN 410 THEN 'Livelink Physical Object Module' WHEN 411 THEN 'Livelink Physical Object Module' WHEN 412 THEN 'Livelink Physical Object Module' WHEN 550 THEN 'Records Management' WHEN 552 THEN 'Hold Maintenance' WHEN 553 THEN 'RSI' WHEN 554 THEN 'Disposition' WHEN 556 THEN 'Table Maintenan! ce' WHEN 666 THEN 'MeetingZone Meeting Room' WHEN 120374 THEN 'Appearance HTML' ELSE 'Unknown' END "Object Type", DTree_1.Name AS [Object Location],DTree.Name AS [Object Name], CASE DTREE.CATALOG WHEN 0 THEN 'List' WHEN 1 THEN 'Catalog' WHEN 2 THEN 'Hidden' END 'Object Display Type', CASE DTREEACL.RIGHTID WHEN '-1' THEN 'Public Access' WHEN '-2' THEN 'System Administrators' ELSE 'User ID: ' + STR(DTREEACL.RIGHTID) END [Privileges Assigned To], CASE DTreeACL.Permissions WHEN 128 THEN 'No Rights' WHEN 130 THEN 'S' WHEN 36995 THEN 'S/SC' WHEN 36999 THEN 'S/SC/AI' WHEN 62666 THEN 'S/M' WHEN 65670 THEN 'S/M/AI' WHEN 102531 THEN 'S/SC/M' WHEN 102535 THEN 'S/SC/M/AI' WHEN 102547 THEN 'S/SC/M/EP' WHEN 102551 THEN 'S/SC/M/EP/AI' WHEN 118915 THEN 'S/SC/M/DV' WHEN 118919 THEN 'S/SC/M/AI/DV' WHEN 118923 THEN 'S/SC/M/DV/D' WHEN 118927 THEN 'S/SC/M/AI/DV/D' WHEN 118931 THEN 'S/SC/M/EP/DV' WHEN 118939 THEN 'S/SC/M/EP/DV/D' WHEN 118935 THEN 'S/SC/M/EP/AI/DV' WHEN 118943 THEN 'S/SC/M/DP/AI/D! V/D' WHEN 127107 THEN 'S/SC/M/DV/R' WHEN 127111 THEN 'S/SC/M/! AI/DV/R' WHEN 127115 THEN 'S/SC/M/DV/D/R' WHEN 127119 THEN 'S/SC/M/AI/DV/D/R' WHEN 127123 THEN 'S/SC/M/EP/DV/R' WHEN 127127 THEN 'S/SC/M/EP/AI/DV/R' WHEN 127131 THEN 'S/SC/M/EP/DV/D/R' WHEN 127135 THEN 'S/SC/M/EP/AI/DV/D/R' WHEN 233603 THEN 'S/SC/M/EA' WHEN 233607 THEN 'S/SC/M/EA/AI' WHEN 233619 THEN 'S/SC/M/EP/EA' WHEN 233623 THEN 'S/SC/M/EP/EA/AI' WHEN 249987 THEN 'S/SC/M/EA/DV' WHEN 249991 THEN 'S/SC/M/EA/AI/DV' WHEN 249995 THEN 'S/SC/M/EA/DV/D' WHEN 249999 THEN 'S/SC/M/EA/AI/DV/D' WHEN 250003 THEN 'S/SC/M/EP/EA/DV' WHEN 250007 THEN 'S/SC/M/EP/EA/AI/DV' WHEN 250011 THEN 'S/SC/M/EP/EA/DV/D' WHEN 250015 THEN 'S/SC/M/EP/EA/AI/DV/D' WHEN 258179 THEN 'S/SC/M/EA/DV/R' WHEN 258183 THEN 'S/SC/M/EA/AI/DV/R' WHEN 258187 THEN 'S/SC/M/EA/DV/D/R' WHEN 258191 THEN 'S/SC/M/EA/AI/DV/D/R' WHEN 258195 THEN 'S/SC/M/EP/EA/DV/R' WHEN 258199 THEN 'S/SC/M/EP/EA/AI/DV/R' WHEN 258203 THEN 'S/SC/M/EP/EA/DV/D/R' WHEN 258207 THEN 'Full Permissions' WHEN 16777215 THEN 'Admin' ELSE 'New: ' + STR(DTree!ACL.Permissions) END Permissions, KUAF.FirstName + ' ' + KUAF.LastName as [User Name], KUAF.Name "Group Name/Login" FROM DTreeACL INNER JOIN DTree ON DTreeACL.DataID = DTree.DataID INNER JOIN KUAF ON DTreeACL.RightID = KUAF.ID INNER JOIN DTree DTree_1 ON DTree.ParentID = DTree_1.DataID WHERE (DTreeACL.ACLType = 0) AND (DTreeACL.ParentID <> - 1) AND (DTreeACL.Permissions <> 128) and kuaf.deleted=0 and DTree.ParentID = :A1 AND (1=1) ORDER BY DTree_1.Name, DTree.Name]

Thanks,
David

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, February 11, 2005 8:03 AM
To: eLink Recipient
Subject: RE RE RE Report to see who has permissions to an Object (Folder) within Livelink

RE RE RE Report to see who has permissions to an Object (Folder) within Livelink Posted by Kish, Leon on 02/11/2005 10:57 AM

Hello David,

I'm not sure why that is but if you want to build it as a new LiveReport here goes:

Title: Permissions on a Given Folder

Inputs: Type: Container Prompt: Enter Folder

SQL (cut it and paste it obviously):
SELECT DTREEACL.DATAID "Object ID", CASE DTree.SubType WHEN 0 THEN 'Folder' WHEN 1 THEN 'Alias' WHEN 2 THEN 'Generation' WHEN 128 THEN 'Workflow Map' WHEN 130 THEN 'Topic' WHEN 131 THEN 'Category' WHEN 132 THEN 'Category Folder' WHEN 133 THEN 'Categories Volume' WHEN 134 THEN 'Reply' WHEN 136 THEN 'Compound Document' WHEN 137 THEN 'Release Volume' WHEN 138 THEN 'Release' WHEN 139 THEN 'Revision' WHEN 140 THEN 'URL' WHEN 141 THEN 'Enterprise Workspace' WHEN 142 THEN 'Personal Workspace' WHEN 143 THEN 'Discussion Volume' WHEN 144 THEN 'Document' WHEN 145 THEN 'Text Document' WHEN 148 THEN 'System Volume' WHEN 150 THEN 'Livelink' WHEN 153 THEN 'Workflow Step' WHEN 154 THEN 'Workflow Attachments' WHEN 161 THEN 'Workflow Volume' WHEN 162 THEN 'Workflows Edit Volume' WHEN 180 THEN 'Domain Workspace' WHEN 188 THEN 'Workflow Status' WHEN 189 THEN 'Workflow' WHEN 198 THEN 'Classifications' WHEN 201 THEN 'Project Workspace' WHEN 202 THEN 'Project' WHEN 204 THEN 'Task List' WHEN 205 TH! EN 'Task Group' WHEN 206 THEN 'Task' WHEN 207 THEN 'Channel' WHEN 208 THEN 'News' WHEN 209 THEN 'Channel Volume' WHEN 210 THEN 'Task List Volume' WHEN 211 THEN 'Reports Volume' WHEN 212 THEN 'Milestone' WHEN 215 THEN 'Discussion' WHEN 218 THEN 'Poll' WHEN 223 THEN 'Form' WHEN 226 THEN 'HTML View' WHEN 230 THEN 'Form Template' WHEN 231 THEN 'Submit Version' WHEN 257 THEN 'Livelink Search Engine' WHEN 258 THEN 'Query' WHEN 259 THEN 'Enterprise Extractor' WHEN 260 THEN 'Proxy' WHEN 268 THEN 'Template Folder' WHEN 269 THEN 'Search Manager' WHEN 270 THEN 'Data Flow Manager' WHEN 271 THEN 'Process' WHEN 272 THEN 'Enterprise Search Engine' WHEN 275 THEN 'Slice Folder' WHEN 276 THEN 'Data Source Folder' WHEN 277 THEN 'Directory Walker' WHEN 278 THEN 'Search Result Snapshot' WHEN 280 THEN 'Spider' WHEN 281 THEN 'Index Engine' WHEN 282 THEN 'HTML Conversion' WHEN 285 THEN 'XML Activator Producer' WHEN 286 THEN 'XML Activator Consumer' WHEN 287 THEN 'XML Activator Intermediate' WHEN 28! 8 THEN 'XML Activator Filter' WHEN 289 THEN 'XML Activator' W! HEN 290 THEN 'Backup Manager' WHEN 291 THEN 'Backup Process' WHEN 292 THEN 'Search Template' WHEN 293 THEN 'Enterprise Importer' WHEN 294 THEN '2 Way Tee' WHEN 299 THEN 'LiveReport' WHEN 301 THEN 'Personal Workspace' WHEN 302 THEN 'Projects' WHEN 303 THEN 'News' WHEN 304 THEN 'Reports' WHEN 305 THEN 'Assignments' WHEN 306 THEN 'Favorites' WHEN 307 THEN 'Queries' WHEN 308 THEN 'Snapshots' WHEN 309 THEN 'LiveReports' WHEN 335 THEN 'XML DTD' WHEN 336 THEN 'XML DTD Volume' WHEN 385 THEN 'Prospector' WHEN 387 THEN 'Prospector Snapshot' WHEN 391 THEN 'Collector' WHEN 392 THEN 'Collector Folder' WHEN 400 THEN 'External Project' WHEN 401 THEN 'Installation' WHEN 402 THEN 'Deleted Documents Volume' WHEN 410 THEN 'Livelink Physical Object Module' WHEN 411 THEN 'Livelink Physical Object Module' WHEN 412 THEN 'Livelink Physical Object Module' WHEN 550 THEN 'Records Management' WHEN 552 THEN 'Hold Maintenance' WHEN 553 THEN 'RSI' WHEN 554 THEN 'Disposition' WHEN 556 THEN 'Table Maintenan! ce' WHEN 666 THEN 'MeetingZone Meeting Room' WHEN 120374 THEN 'Appearance HTML' ELSE 'Unknown' END "Object Type", DTree_1.Name AS [Object Location],DTree.Name AS [Object Name], CASE DTREE.CATALOG WHEN 0 THEN 'List' WHEN 1 THEN 'Catalog' WHEN 2 THEN 'Hidden' END 'Object Display Type', CASE DTREEACL.RIGHTID WHEN '-1' THEN 'Public Access' WHEN '-2' THEN 'System Administrators' ELSE 'User ID: ' + STR(DTREEACL.RIGHTID) END [Privileges Assigned To], CASE DTreeACL.Permissions WHEN 128 THEN 'No Rights' WHEN 130 THEN 'S' WHEN 36995 THEN 'S/SC' WHEN 36999 THEN 'S/SC/AI' WHEN 62666 THEN 'S/M' WHEN 65670 THEN 'S/M/AI' WHEN 102531 THEN 'S/SC/M' WHEN 102535 THEN 'S/SC/M/AI' WHEN 102547 THEN 'S/SC/M/EP' WHEN 102551 THEN 'S/SC/M/EP/AI' WHEN 118915 THEN 'S/SC/M/DV' WHEN 118919 THEN 'S/SC/M/AI/DV' WHEN 118923 THEN 'S/SC/M/DV/D' WHEN 118927 THEN 'S/SC/M/AI/DV/D' WHEN 118931 THEN 'S/SC/M/EP/DV' WHEN 118939 THEN 'S/SC/M/EP/DV/D' WHEN 118935 THEN 'S/SC/M/EP/AI/DV' WHEN 118943 THEN 'S/SC/M/DP/AI/D! V/D' WHEN 127107 THEN 'S/SC/M/DV/R' WHEN 127111 THEN 'S/SC/M/! AI/DV/R' WHEN 127115 THEN 'S/SC/M/DV/D/R' WHEN 127119 THEN 'S/SC/M/AI/DV/D/R' WHEN 127123 THEN 'S/SC/M/EP/DV/R' WHEN 127127 THEN 'S/SC/M/EP/AI/DV/R' WHEN 127131 THEN 'S/SC/M/EP/DV/D/R' WHEN 127135 THEN 'S/SC/M/EP/AI/DV/D/R' WHEN 233603 THEN 'S/SC/M/EA' WHEN 233607 THEN 'S/SC/M/EA/AI' WHEN 233619 THEN 'S/SC/M/EP/EA' WHEN 233623 THEN 'S/SC/M/EP/EA/AI' WHEN 249987 THEN 'S/SC/M/EA/DV' WHEN 249991 THEN 'S/SC/M/EA/AI/DV' WHEN 249995 THEN 'S/SC/M/EA/DV/D' WHEN 249999 THEN 'S/SC/M/EA/AI/DV/D' WHEN 250003 THEN 'S/SC/M/EP/EA/DV' WHEN 250007 THEN 'S/SC/M/EP/EA/AI/DV' WHEN 250011 THEN 'S/SC/M/EP/EA/DV/D' WHEN 250015 THEN 'S/SC/M/EP/EA/AI/DV/D' WHEN 258179 THEN 'S/SC/M/EA/DV/R' WHEN 258183 THEN 'S/SC/M/EA/AI/DV/R' WHEN 258187 THEN 'S/SC/M/EA/DV/D/R' WHEN 258191 THEN 'S/SC/M/EA/AI/DV/D/R' WHEN 258195 THEN 'S/SC/M/EP/EA/DV/R' WHEN 258199 THEN 'S/SC/M/EP/EA/AI/DV/R' WHEN 258203 THEN 'S/SC/M/EP/EA/DV/D/R' WHEN 258207 THEN 'Full Permissions' WHEN 16777215 THEN 'Admin' ELSE 'New: ' + STR(DTree!
ACL.Permissions) END Permissions, KUAF.FirstName + ' ' + KUAF.LastName as [User Name], KUAF.Name "Group Name/Login" FROM DTreeACL INNER JOIN DTree ON DTreeACL.DataID = DTree.DataID INNER JOIN KUAF ON DTreeACL.RightID = KUAF.ID INNER JOIN DTree DTree_1 ON DTree.ParentID = DTree_1.DataID WHERE (DTreeACL.ACLType = 0) AND (DTreeACL.ParentID <> - 1) AND (DTreeACL.Permissions <> 128) and kuaf.deleted=0 and DTree.ParentID = %1 AND %2 ORDER BY DTree_1.Name, DTree.Name

Param %1: User Input 1

Param %2: Filter Permissions

Make it an 'Auto LiveReport' and you can 'Configure' to allow 100% width and columns to wrap.

Good luck,
Leon

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Topic: Report to see who has permissions to an Object (Folder) within Livelink
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3843113&objAction=view

Discussion: Livelink LiveReports Discussion https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view

Livelink Server: https://knowledge.opentext.com/knowledge/livelink.exe

David_Kim_(seamon01admin_-_(deleted))

Message from David Kim via eLinkFigured it out. There were some extra "!" that didn't belong in thecode. This report is great. Thanks for sharing this.Thanks,David-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, February 11, 2005 8:03 AMTo: eLink RecipientSubject: RE RE RE Report to see who has permissions to an Object(Folder) within LivelinkRE RE RE Report to see who has permissions to an Object (Folder) withinLivelink Posted by Kish, Leon on 02/11/2005 10:57 AMHello David,I'm not sure why that is but if you want to build it as a new LiveReporthere goes:Title: Permissions on a Given FolderInputs: Type: Container Prompt: Enter FolderSQL (cut it and paste it obviously):SELECT DTREEACL.DATAID "Object ID", CASE DTree.SubType WHEN 0 THEN'Folder' WHEN 1 THEN 'Alias' WHEN 2 THEN 'Generation' WHEN 128 THEN'Workflow Map' WHEN 130 THEN 'Topic' WHEN 131 THEN 'Category' WHEN 132THEN 'Category Folder' WHEN 133 THEN 'Categories Volume' WHEN 134 THEN'Reply' WHEN 136 THEN 'Compound Document' WHEN 137 THEN 'Release Volume'WHEN 138 THEN 'Release' WHEN 139 THEN 'Revision' WHEN 140 THEN 'URL'WHEN 141 THEN 'Enterprise Workspace' WHEN 142 THEN 'Personal Workspace'WHEN 143 THEN 'Discussion Volume' WHEN 144 THEN 'Document' WHEN 145 THEN'Text Document' WHEN 148 THEN 'System Volume' WHEN 150 THEN 'Livelink'WHEN 153 THEN 'Workflow Step' WHEN 154 THEN 'Workflow Attachments' WHEN161 THEN 'Workflow Volume' WHEN 162 THEN 'Workflows Edit Volume' WHEN180 THEN 'Domain Workspace' WHEN 188 THEN 'Workflow Status' WHEN 189THEN 'Workflow' WHEN 198 THEN 'Classifications' WHEN 201 THEN 'ProjectWorkspace' WHEN 202 THEN 'Project' WHEN 204 THEN 'Task List' WHEN 205TH! EN 'Task Group' WHEN 206 THEN 'Task' WHEN 207 THEN 'Channel' WHEN208 THEN 'News' WHEN 209 THEN 'Channel Volume' WHEN 210 THEN 'Task ListVolume' WHEN 211 THEN 'Reports Volume' WHEN 212 THEN 'Milestone' WHEN215 THEN 'Discussion' WHEN 218 THEN 'Poll' WHEN 223 THEN 'Form' WHEN 226THEN 'HTML View' WHEN 230 THEN 'Form Template' WHEN 231 THEN 'SubmitVersion' WHEN 257 THEN 'Livelink Search Engine' WHEN 258 THEN 'Query'WHEN 259 THEN 'Enterprise Extractor' WHEN 260 THEN 'Proxy' WHEN 268 THEN'Template Folder' WHEN 269 THEN 'Search Manager' WHEN 270 THEN 'DataFlow Manager' WHEN 271 THEN 'Process' WHEN 272 THEN 'Enterprise SearchEngine' WHEN 275 THEN 'Slice Folder' WHEN 276 THEN 'Data Source Folder'WHEN 277 THEN 'Directory Walker' WHEN 278 THEN 'Search Result Snapshot'WHEN 280 THEN 'Spider' WHEN 281 THEN 'Index Engine' WHEN 282 THEN 'HTMLConversion' WHEN 285 THEN 'XML Activator Producer' WHEN 286 THEN 'XMLActivator Consumer' WHEN 287 THEN 'XML Activator Intermediate' WHEN 28!8 THEN 'XML Activator Filter' WHEN 289 THEN 'XML Activator' W! HEN 290THEN 'Backup Manager' WHEN 291 THEN 'Backup Process' WHEN 292 THEN'Search Template' WHEN 293 THEN 'Enterprise Importer' WHEN 294 THEN '2Way Tee' WHEN 299 THEN 'LiveReport' WHEN 301 THEN 'Personal Workspace'WHEN 302 THEN 'Projects' WHEN 303 THEN 'News' WHEN 304 THEN 'Reports'WHEN 305 THEN 'Assignments' WHEN 306 THEN 'Favorites' WHEN 307 THEN'Queries' WHEN 308 THEN 'Snapshots' WHEN 309 THEN 'LiveReports' WHEN 335THEN 'XML DTD' WHEN 336 THEN 'XML DTD Volume' WHEN 385 THEN 'Prospector'WHEN 387 THEN 'Prospector Snapshot' WHEN 391 THEN 'Collector' WHEN 392THEN 'Collector Folder' WHEN 400 THEN 'External Project' WHEN 401 THEN'Installation' WHEN 402 THEN 'Deleted Documents Volume' WHEN 410 THEN'Livelink Physical Object Module' WHEN 411 THEN 'Livelink PhysicalObject Module' WHEN 412 THEN 'Livelink Physical Object Module' WHEN 550THEN 'Records Management' WHEN 552 THEN 'Hold Maintenance' WHEN 553 THEN'RSI' WHEN 554 THEN 'Disposition' WHEN 556 THEN 'Table Maintenan! ce'WHEN 666 THEN 'MeetingZone Meeting Room' WHEN 120374 THEN 'AppearanceHTML' ELSE 'Unknown' END "Object Type", DTree_1.Name AS [ObjectLocation],DTree.Name AS [Object Name], CASE DTREE.CATALOG WHEN 0 THEN'List' WHEN 1 THEN 'Catalog' WHEN 2 THEN 'Hidden' END 'Object DisplayType', CASE DTREEACL.RIGHTID WHEN '-1' THEN 'Public Access' WHEN '-2'THEN 'System Administrators' ELSE 'User ID: ' + STR(DTREEACL.RIGHTID)END [Privileges Assigned To], CASE DTreeACL.Permissions WHEN 128 THEN'No Rights' WHEN 130 THEN 'S' WHEN 36995 THEN 'S/SC' WHEN 36999 THEN'S/SC/AI' WHEN 62666 THEN 'S/M' WHEN 65670 THEN 'S/M/AI' WHEN 102531THEN 'S/SC/M' WHEN 102535 THEN 'S/SC/M/AI' WHEN 102547 THEN 'S/SC/M/EP'WHEN 102551 THEN 'S/SC/M/EP/AI' WHEN 118915 THEN 'S/SC/M/DV' WHEN 118919THEN 'S/SC/M/AI/DV' WHEN 118923 THEN 'S/SC/M/DV/D' WHEN 118927 THEN'S/SC/M/AI/DV/D' WHEN 118931 THEN 'S/SC/M/EP/DV' WHEN 118939 THEN'S/SC/M/EP/DV/D' WHEN 118935 THEN 'S/SC/M/EP/AI/DV' WHEN 118943 THEN'S/SC/M/DP/AI/D! V/D' WHEN 127107 THEN 'S/SC/M/DV/R' WHEN 127111 THEN'S/SC/M/! AI/DV/R' WHEN 127115 THEN 'S/SC/M/DV/D/R' WHEN 127119 THEN'S/SC/M/AI/DV/D/R' WHEN 127123 THEN 'S/SC/M/EP/DV/R' WHEN 127127 THEN'S/SC/M/EP/AI/DV/R' WHEN 127131 THEN 'S/SC/M/EP/DV/D/R' WHEN 127135 THEN'S/SC/M/EP/AI/DV/D/R' WHEN 233603 THEN 'S/SC/M/EA' WHEN 233607 THEN'S/SC/M/EA/AI' WHEN 233619 THEN 'S/SC/M/EP/EA' WHEN 233623 THEN'S/SC/M/EP/EA/AI' WHEN 249987 THEN 'S/SC/M/EA/DV' WHEN 249991 THEN'S/SC/M/EA/AI/DV' WHEN 249995 THEN 'S/SC/M/EA/DV/D' WHEN 249999 THEN'S/SC/M/EA/AI/DV/D' WHEN 250003 THEN 'S/SC/M/EP/EA/DV' WHEN 250007 THEN'S/SC/M/EP/EA/AI/DV' WHEN 250011 THEN 'S/SC/M/EP/EA/DV/D' WHEN 250015THEN 'S/SC/M/EP/EA/AI/DV/D' WHEN 258179 THEN 'S/SC/M/EA/DV/R' WHEN258183 THEN 'S/SC/M/EA/AI/DV/R' WHEN 258187 THEN 'S/SC/M/EA/DV/D/R' WHEN258191 THEN 'S/SC/M/EA/AI/DV/D/R' WHEN 258195 THEN 'S/SC/M/EP/EA/DV/R'WHEN 258199 THEN 'S/SC/M/EP/EA/AI/DV/R' WHEN 258203 THEN'S/SC/M/EP/EA/DV/D/R' WHEN 258207 THEN 'Full Permissions' WHEN 16777215THEN 'Admin' ELSE 'New: ' + STR(DTree!ACL.Permissions) END Permissions, KUAF.FirstName + ' ' + KUAF.LastNameas [User Name], KUAF.Name "Group Name/Login" FROM DTreeACL INNER JOINDTree ON DTreeACL.DataID = DTree.DataID INNER JOIN KUAF ONDTreeACL.RightID = KUAF.ID INNER JOIN DTree DTree_1 ON DTree.ParentID =DTree_1.DataID WHERE (DTreeACL.ACLType = 0) AND (DTreeACL.ParentID <> -1) AND (DTreeACL.Permissions <> 128) and kuaf.deleted=0 andDTree.ParentID = %1 AND %2 ORDER BY DTree_1.Name, DTree.NameParam %1: User Input 1Param %2: Filter PermissionsMake it an 'Auto LiveReport' and you can 'Configure' to allow 100% widthand columns to wrap.Good luck,Leon[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Report to see who has permissions to an Object (Folder)within Livelinkhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3843113&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe

Michael_Heisch_(sglcadmin12_-_(deleted))

Thanks for this report. It shows the access list, but information in "default" section of permissions is missing. Owner, Owner Group and public access is not displayed.Kind Regards, Veronika

Steve_McDonough

Hello Veronika,The information displayed is caused by the ACLType in the DTreeACL table. The report restricts the view to include only those items in the Access list area. If you want to expand that to include permissions from the Default section, simply remove "(DTreeACL.ACLType = 0) AND " from the SQL statement immediately following the WHERE. ACL type 0 is the regular ACL of the node. Removing the mask from the statement will open up all ACL types to the report.If you change the 0 in the above statement to a 1, you will get only Owner permissions, 2 - Owner Group and 3 - public access. Therefore, you can customize the report to focus on a particular area or open it up to see all.Leon

Goldman_Opentext_KC_Generic_#1_(GOLSAC02User1_(Del

I get 'No Results' no matter what Folder ID I enter.I'm running LL 9.1 on Sybase.Any idea? Thanks alot.John