Date User Deleted

I found a LiveReport that had been posted here in the LiveReport Discussions. It's great--it gives me all deleted usersSELECT ID, NAME, LASTNAME, FIRSTNAME, OFFICELOCATION FROM KUAF WHERE DELETED > 0 ORDER BY LASTNAMEHow can I modify this report to include the date that the user was deleted?Thank you for your help.

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

One solution is taken from:

https://knowledge.opentext.com/knowledge/llisapi.dll/open/12475615

...and it is:

ORACLE:<?XML:NAMESPACE PREFIX = O />

/* USERS WHO HAVE BEEN DELETED AND WHEN */
SELECT * FROM DAUDITNEW
WHERE AUDITSTR = 'Delete' AND USERID IN (SELECT ID FROM KUAF WHERE DELETED = 1 AND TYPE = 0)

SQL Server:

/* USERS WHO HAVE BEEN DELETED AND WHEN */
SELECT * FROM DAUDITNEW
WHERE AUDITSTR = 'Delete' AND USERID IN (SELECT ID FROM KUAF WHERE DELETED = 1 AND TYPE = 0)

Let me know if that helps...

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, October 24, 2008 5:57 PM
To: eLink Recipient
Subject: Date User Deleted

Date User Deleted

Posted by mary.corona@ejgallo.com (Corona, Mary) on 10/24/2008 05:54 PM

I found a LiveReport that had been posted here in the LiveReport Discussions. It's great--it gives me all deleted users

SELECT ID, NAME, LASTNAME, FIRSTNAME, OFFICELOCATION FROM KUAF WHERE DELETED > 0 ORDER BY LASTNAME

How can I modify this report to include the date that the user was deleted?

Thank you for your help.

Mary_Slane_Corona

BhupinderIt works great. Thank you for your help.Question: I notice it only goes back to November 2006 (when we upgraded to 9.5 sp1). Are there other tables for earlier information?

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Check the DAudit table (used in versions of Livelink prior to 9.5.x). There is an option on the Livelink Adminstration pages ("Administer Event Auditing" section) to migrate the records from that table into the newer DAuditNew table.

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, November 06, 2008 1:23 PM
To: eLink Recipient
Subject: Bhupinder

Bhupinder		Posted by mary.corona@ejgallo.com (Corona, Mary) on 11/06/2008 01:20 PM
In reply to: RE Date User Deleted		Posted by bsingh (Singh, Bhupinder) on 10/26/2008 08:48 AM

Bhupinder
It works great. Thank you for your help.
Question: I notice it only goes back to November 2006 (when we upgraded to 9.5 sp1). Are there other tables for earlier information?

komments

Message from Greg Kellogg <gkellogg@opentext.com> via eLink

eLink

You probably didn’t migrate yourdAudit records when you upgraded. You should still be able to do thatthough. I am attaching the KB article that talks about this process.

Greg Kellogg

(361) 815-8950

From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, November 06, 200812:23 PM
To: eLink Recipient
Subject: Bhupinder

Bhupinder		Posted by mary.corona@ejgallo.com (Corona, Mary) on 11/06/2008 01:20 PM
In reply to: RE Date User Deleted		Posted by bsingh (Singh, Bhupinder) on 10/26/2008 08:48 AM

Bhupinder
It works great. Thank you for your help.
Question: I notice it only goes back to November 2006 (when we upgraded to 9.5 sp1). Are there other tables for earlier information?