Deleted Documents and Folders by user

Chris_Black

Content server newbie here,

Someone has deleted the pre-built report called “Deleted documents by [User]”  from our system. Can anyone here provide me with the sql necessary to recreate this live report? Also a "Deleted folders by [User]" would be a nice to have if you are feeling generous.

 

Thanks in advance

Colin_Schmidt

ORACLE:

You'll have to run through the DAUDITNEW table looking for "Folders" by a User.  Depending upon the size of your DB, an LR might work or might not return from a lengthy run.  You may have to run it as a SQL report from a DB Tool.

Deleted Folders

Select da.eventid, da.auditstr, da.auditdate, da.dataid, da.performerid, k.name, da.value1||':'||da.value2 /* Value1 is the path, Value2 is the folder  */

from dauditnew da 

join kuaf k on da.performerid = k.id 

where da.auditid = 2 and da.subtype = 0 and da.performerid = %1 

/* you can sub this line in for the the above to get just documents */

where da.auditid = 2 and da.subtype = 144 and da.performerid = %1 

Some of it you may not want.  In each case, "VALUE1" is the path and "VALUE2" is the name of the Deleted Object.

Colin J. Schmidt

Opentext Content Server Support Admin

colin.schmidt@mwv.com
+1 804.444 5012 (Direct)

 
MWV
501 South 5th Street
Richmond, VA 23219-0501
mwv.com

On Mon, May 19, 2014 at 3:12 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Deleted Documents and Folders by user

Posted bychris-black@idexx.com (Black, Chris)On 05/19/2014 03:08 PM

Content server newbie here, Someone has deleted the pre-built report called “Deleted documents by [User]”  from our system. Can anyone here provide me with the sql necessary to recreate this live report? Also a "Deleted folders by [User]" would be a nice to have if you are feeling generous.   Thanks in advance

---

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

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.