How to find number of documents in Enterprise and Personal work space per user

Saravanan_Gurusamy

I am new to Live Reports, could some one provide SQL to find How to find number of documents in Enterprise and Personal work space per user ?

Thanks

Colin_Schmidt

ORACLE: Here's a couple that will get most, but not all.  It doesn't handle documents under Projects.  You can see how similar they are.  The OWNERID of PWS is the KUAF.ID.  The OWNERID of Enterprise is '-2000', which will exclude the PWS from the count.

select k.id, k.name "GID", count(*) 

from kuaf k

join dtree dt on k.id = abs(dt.ownerid) and dt.subtype = 144

where k.type = 0 and k.deleted = 0 

group by k.id, k.name

select k.id, k.name "GID", count(*) 

from kuaf k

join dtree dt on dt.ownerid = -2000 and dt.subtype = 144 and dt.createdby = k.id

where k.type = 0 and k.deleted = 0 

group by k.id, k.name

Colin J. 

On Thu, Feb 6, 2014 at 8:35 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

How to find number of documents in Enterprise and Personal work space per user

Posted bysaravanan.gurusamy@sce.com (Gurusamy, Saravanan)On 02-06-2014 20:32

I am new to Live Reports, could some one provide SQL to find How to find number of documents in Enterprise and Personal work space per user ? Thanks

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.