How to identify what user Deleted a File or Folder?

I need to write a Livereport that will identify the time and the user when a file or folder is deleted. Anyone got something that will help?

Find more posts tagged with

Comments

eLink User

Message from David Slimmon via eLinkHi there,Will you already know the Id of the folder that you want to track? Are youauditing these events already? To confirm, you can check the AdministerEvent Auditing section of the Livelink Administration pages.Regards,David___________________________________________O P E N T E X T C O R P O R A T I O NDavid Slimmon, M.L.I.S.Supervisor - Customer Supporthttps://knowledge.opentext.comdslimmon@opentext.com-----Original Message-----How to identify what user Deleted a File or Folder?Posted by GULFAdmin on 05/06/2002 11:24 AMI need to write a Livereport that will identify the time and the user when afile or folder is deleted. Anyone got something that will help?

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Assuming that you're auditing the "delete" event (as Dave asked), you can query the daudit table for the "DELETE" event. AuditDate contains the date and time it happened, DataID is the ID of the item deleted, DName is the name of the item deleted, and UserID is the ID of the user who did the deletion. You can join DAudit.UserID to KUAF.ID to get the user's name.

Hoping that helps,

Marie Lindsay

-----Original Message-----
From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of eLink Discussion: Livelink LiveReports Discussion
Sent: Monday, May 06, 2002 10:24 AM
To: eLink Recipient
Subject: How to identify what user Deleted a File or Folder?

How to identify what user Deleted a File or Folder? Posted by GULFAdmin (Davidson, Robert) on 05/06/2002 11:24 AM

I need to write a Livereport that will identify the time and the user when a file or folder is deleted. Anyone got something that will help?

2-04-2014_1-04-55_AM.png

John_Leth-Nissen

I do have auditing for the Delete events turned on. I'm relatively new to LiveReports and having problems with the joining DAudit.UserID to KUAF.ID to get the info I need. Can you Help?

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Try

select kuaf.name, daudit.dname, daudit.auditdate from daudit, kuaf where daudit.event = "DELETE" and kuaf.id = daudit.userid

This is a pretty simplistic report and could get long very quickly. You might decide to restrict by date or something as you refine what you want.

-----Original Message-----
From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of eLink Discussion: Livelink LiveReports Discussion
Sent: Tuesday, May 07, 2002 8:59 AM
To: eLink Recipient
Subject: RERE How to identify what user Deleted a File or Folder? 2

RERE How to identify what user Deleted a File or Folder? 2 Posted by GULFAdmin (Davidson, Robert) on 05/07/2002 09:57 AM
In reply to: RE How to identify what user Deleted a File or Folder? 2 Posted by eLink on 05/06/2002 12:12 PM

I do have auditing for the Delete events turned on. I'm relatively new to LiveReports and having problems with the joining DAudit.UserID to KUAF.ID to get the info I need. Can you Help?