"Where Used" for Groups

Sandy_Craven

Is there a report that can be run to identify all the locations for a group? For example, each folder that a group has permissions to -- a "where used" for groups. We are running 9.2 SP1. Thank you.

Brian_Pariseau

I recently worked with support on a similar permission problem. Here is some SQL that should help.select kuaf.id, kuaf.name, dtree.name, dtree.dataid, dtree.parentid, dtree.subtype, dtreeacl.permissions, dtreeacl.acltype, dtreeacl.owneridfrom dtree, dtreeacl, kuafwhere dtree.ownerid=dtreeacl.ownerid and dtree.parentid=dtreeacl.parentid and dtree.dataid=dtreeacl.dataid and dtreeacl.rightid=kuaf.id and dtree.subtype=0 and dtreeacl.ownerid=-2000 and dtreeacl.acltype IN (0,2)and kuaf.id=14534 and dtreeacl.permissions>130;DTreeACL.ACLType: 0 = The group has been explicitly assigned to the permissions list of the object. 2 = The group of the user which owns the object (i.e. group owner).DTree.Subtype:0 = Folder.Kuaf.ID: The id of the group you want to view permissions for.Dtreeacl.Permissions: 128=no permissions, 130=See, 36995=See/See Contents, 102531=See/SC/Modify, 233603=See/SC/Mod/EA, 233607=See/SC/Mod/EA/AI, etc.