Deleted Folder with Documents

Hi,

We are using CS10 and SQL Server. Someone has deleted a whole lot of folders with documents within them. I need to retrieve these documents, but every query I write doesn't give me results. So, I want to use the dtreeancestors table, dtree, dauditnew and maybe the deleteddocs tables, but every time I run it I get nothing back.

select dan.auditstr, dan.auditdate, dan.dataid, dan.valuekey, dan.value1, dan.value2,dan.performerid,dan.subtype,dt.name
from dauditnew dan, dtree dt, dtreeancestors dta
where dan.auditdate > %1
and dan.auditdate < %2
and dan.dataid=dt.dataid
and dta.dataid=dt.dataid
and dta.ancestorid = %3

I have tried the above on a test folder and I get nothing back either.

Thanks in advance.

Find more posts tagged with

Comments

Colin_Schmidt

You would find the Delete operation and Folder names in the DAUDITNEW table. If you have the RecycleBin installed, you can restore them from there.

In Oracle, to find the names:

select da.eventid, da.auditdate, da.auditstr, da.performerid, k.userid "Performer", da.dataid, da.value2 "Folder", da.value1 "Path"

from dauditnew da

join kuaf k on da.performerid = k.id

where da.AUDITID = 2 and da.subtype = 0 and (da.auditdate >= %1 and da.auditdate <= %2)

order by da.eventid

Colin J.

On Fri, Jan 29, 2016 at 10:49 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Deleted Folder with Documents Posted byAli, ImadOn 01/29/2016 10:45 AM

Hi,We are using CS10 and SQL Server. Someone has deleted a whole lot of folders with documents within them. I need to retrieve these documents, but every query I write doesn't give me results. So, I want to use the dtreeancestors table, dtree, dauditnew and maybe the deleteddocs tables, but every time I run it I get nothing back.select dan.auditstr, dan.auditdate, dan.dataid, dan.valuekey, dan.value1, dan.value2,dan.performerid,dan.subtype,dt.name
from dauditnew dan, dtree dt, dtreeancestors dta
where dan.auditdate > %1
and dan.auditdate < %2
and dan.dataid=dt.dataid
and dta.dataid=dt.dataid
and dta.ancestorid = %3I have tried the above on a test folder and I get nothing back either. Thanks in advance.
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from WestRockCompany (www.westrock.com) or itssubsidiaries, which may be confidential, privileged or otherwise protected fromdisclosure. The information is intended to be disclosed to and used by only thenamed recipient(s). If you are not the intendedrecipient, then your review, use, disclosure, printing, copying, ordistribution of this message or its contents is prohibited. If you havereceived this message in error, please notify WestRock immediately at postmaster@westrock.com, and delete themessage from your system. Unless previously authorized in writing, thismessage does not constitute an offer, acceptance, or agreement of any kind.Sender is not liable for damage, errors or omissions related to or caused bytransmission of this message. © WestRock Company.

Greg Kellogg

Are you running Recycle Bin? If so, probably easiest to recover from there. If not, Document Undelete would likely suffice too.

Greg Kellogg | gkellogg@iqbginc.com | P 361-758-3762 | C 361-413-9200

the iQ Business Group

intelligence. applied.

www.IQBGinc.com

From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>
Sent: Friday, January 29, 2016 9:49 AM
To: eLink Recipient
Subject: Deleted Folder with Documents

Deleted Folder with Documents

Posted by Ali, Imad On 01/29/2016 10:45 AM

Hi,We are using CS10 and SQL Server. Someone has deleted a whole lot of folders with documents within them. I need to retrieve these documents, but every query I write doesn't give me results. So, I want to use the dtreeancestors table, dtree, dauditnew and maybe the deleteddocs tables, but every time I run it I get nothing back.select dan.auditstr, dan.auditdate, dan.dataid, dan.valuekey, dan.value1, dan.value2,dan.performerid,dan.subtype,dt.name
from dauditnew dan, dtree dt, dtreeancestors dta
where dan.auditdate > %1
and dan.auditdate < %2
and dan.dataid=dt.dataid
and dta.dataid=dt.dataid
and dta.ancestorid = %3I have tried the above on a test folder and I get nothing back either. Thanks in advance.

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

****** CONFIDENTIALITY NOTICE ****** This message and any attachments are confidential and for the sole use of the intended recipient. If you are not the intended recipient, any copying, forwarding, disclosure, distribution or use of any part of this message or its attachments is strictly prohibited and may be unlawful. If you believe that you received this email in error, please do not read it or any attachments thereto, and notify the sender immediately by email and then delete this message from your system. Thank you.