Display all groups with permissions applied in CS and all the folders they are applied to

I commented on this topic in another forum topic but chose break the scenarios out in more detail here. My query question maybe best served if it is broken into 2 seperate queries. See below.

1. I was looking to find all groups where permissions are applied in CS (including, ancestors, parents & children)? I wasn't getting the results using the query below

            Select A.ID, A.Name from Kuaf A
            Where A.Type = 1 And A.ID IN (Select distinct DTA1.RightId From DtreeACL DTA1 where A.ID = DTA1.RightId)
            AND A.ID IN (Select distinct KC.Id from kuafchildren KC join DtreeACL DTA2 on DTA2.RightId = KC.Id Where KC.ChildId = A.Id)
            AND A.Deleted = 0
            Order by A.Name;

2. Secondly, would be to display all the folders each group is permissioned on.

Find more posts tagged with

Comments

Will_Brantley

Hello. Please disregard the first part of this as I have already resolved. I simply would like to display all the folders each group is permissioned on.

appuGmail

does an answer like this help you?

http://www.tek-tips.com/viewthread.cfm?qid=1782546

DtreeACL if the Group is explicitly defined,DTree to get the name and subtype exclusion

..... appnair appunair( Livelink Rocks )

Well, if I called the wrongnumber, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Thu, Nov 30, 2017 at 9:24 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Display all groups with permissions applied in CS and all the folders they are applied to Posted bywbrantley@cvrenergy.com (Brantley, Will)On 11/30/2017 10:22 AM

Hello. Please disregard the first part of this as I have already resolved. I simply would like to display all the folders each group is permissioned on.
[To post a comment, use the normal reply function]
Topic: Display all groups with permissions applied in CS and all the folders they are applied to
Forum: Content Server LiveReports Forum
Content Server: My Support

Alister Grigg

You mean "each selected group is permissioned on"? If you take out the word 'selected' you essentially get every item in the tree......