Need help to filter out folders from user's PWS.

Olga_Bakushchyk_(offsup02admin_-_(deleted))

I'm trying to build LiveReport that allows me to display all folders in the EWS that certain user group does not have permissions to (i.e. Records Management group has to have permissions to all folders in the EWS, so I’m trying to monitor if there are folders that ACL (or ownergroup) is missing.) Obviously, I’m running this report as Admin, because I need to check all possible folders. The downside is that report displays all folders in user’s personal spaces as well. Is there a way to filter such folders? My LL runs on SQL, not Oracle and there is no such thing as ‘start’ and ‘connect by’ to run recursive query. Any help would be appreciated. Olga.

Bhupinder_Singh

Message from Bhupinder Singh via eLinkAny object in a user's personal workspace has as its DTREE.OwnerID the negative value of the user's ID as recorded in KUAF. Maybeyou could use this to filter out Personal Workspace folders.For example, a user (JohnDoe) has a KUAF.ID value of 9635. Any object in his personal workspace, including objects in subfolders,shows an OwnerID value in DTREE of -9635.- Bhupinder------------------------------------------------------------------------- Bhupinder Singh, B.Math., B.Ed. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------------------------- -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Wednesday, February 04, 2004 9:39 AMTo: eLink RecipientSubject: Need help to filter out folders from user's PWS.Need help to filter out folders from user's PWS.Posted by Bakushchyk, Olga on 02/04/2004 09:35 AMI'm trying to build LiveReport that allows me to display all folders in the EWS that certain user group does not have permissions to(i.e. Records Management group has to have permissions to all folders in the EWS, so I'm trying to monitor if there are folders thatACL (or ownergroup) is missing.) Obviously, I'm running this report as Admin, because I need to check all possible folders. Thedownside is that report displays all folders in user's personal spaces as well. Is there a way to filter such folders? My LL runs onSQL, not Oracle and there is no such thing as 'start' and 'connect by' to run recursive query. Any help would be appreciated. Olga.[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe