number of documents a user has created

I need to create a report showing the number of documents created by each user in a specific time frame?

Find more posts tagged with

Comments

I put a report together that allows me to see all documents owned by a named user. My database is Oracle.Set the record limit high enough to include large numbers of documents. Record limit: 100000Inputs: Type = User Prompt= User name?SQL: select * from dtree where (userid=%1)Param %1: = User input 1Report format = live reportAlthough this is very simple, it returns everything owned by a named user, and as a report format =LiveReport, you get a result that allows examining the results. Give it a try, it may give you what you need.Dave Ebels ,, dave.j.ebels@jci.comGlobal Livelink adminJohnson ControlsHolland Michigan

Lindsay_Davies

Message from Lindsay Davies via eLinkHi Shaz,I guess you want some SQL along the following lines (this wasspecifically in Oracle but will work in SQL server if you don't usesysdate (specify a real date instead).select count(*),userid,k.name from dtree d,kuaf k where subtype = 144and createdate > sysdate-100 and d.userid = k.id group by userid,k.name AutoLivereport output format.Subtype=144 for documents onlyYou could specify a start and end date as input parameters and changethe clause to "createdate between %1 and %2"It would return the following from my own little test system... COUNT(*) USERID NAME---------- ---------- ------------------------------ 9 1000 Admin 44 3285 jbloggsEtc.RegardsLindsay DaviesUK-SupportOpen Text.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 17 May 2006 12:32To: eLink RecipientSubject: number of documents a user has creatednumber of documents a user has createdPosted by Amin, Shaz on 05/17/2006 07:27 AMI need to create a report showing the number of documents created byeach user in a specific time frame?[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Shaz_Amin

Thanks Lindsay this is perfect.