Livereport of Public Access into Enterprise

Livelink_Admin_Colombia_(bpcolombiaadmin_-_(delete

Hi,I need a Livereport what show me all items with Public Access permissions enable. We have LL 8.1.5 SP1.Thanks, for your help.....

John W. Simon, Jr.

What permission are you looking for?There are two ways to do this one. One is to join dtree with dtreeacl, but an easier way is query the WPERMISSIONS column in dtree (eliminating the join).So the SQL part would look something like:select * from dtree where wpermissions > 128 start with dataid = 2001 connect by prior dataid = parentidA couple of notes about the query.1). This query is Oracle specific2). 2001 is the dataid for our enterprise. Yours may be different.3). You only need the start with... and connect by... if you want to limit your query to the enterprise. If you take those two things out you will get everything in dtree.Best of Luck,John Simon