Live Report to list group membership of a deleted user

Is there a Live Report that will give me the group membership of a deleted user? I'm using oracle, and am wanting to know what groups a deleted user was a member of.

Find more posts tagged with

Comments

Colin_Schmidt

That's no different than an active user, except you'll need to know the KUAF.ID. You could make it all encompassing and just look for all Deleted Users (kuaf.deleted=1)....or not.

Attached is a LR that you can use to find explicit membership. Just plug the ID into the '%1' area. In the LR, you'd select for a 'number'.

Colin

On Thu, Aug 8, 2013 at 7:01 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Live Report to list group membership of a deleted user Posted bywmader@co.jefferson.co.us (Mader, Walt)On 08-08-2013 18:58

Is there a Live Report that will give me the group membership of a deleted user? I'm using oracle, and am wanting to know what groups a deleted user was a member of.
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

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.

UsersGroups.txt

Bhupinder_Singh

From what I recall, when a user is deleted, his/her corresponding entries from KUAFChildren are deleted. The KUAF entry remains, but modified to reflect the deleted status. As a result, I don't think this would be possible unless you ran the SQL query against a restored copy of the database's KUAF and KUAFChildren tables, a backup for which was taken prior to the user being deleted.

- Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Systems Administrator, Cloud Services
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

Lindsay_Davies

H Walt,

There is no standard report for this.

When a user is deleted, the membership of any real or project groups is destroyed.

However, if you have enabled auditing of group membership actions then you would be able to join KUAF (for deleted users) to DAuditNew to find the events for adding and removing the (now deleted) user to the group/s he had membership of at some time.

It may be some of this info is in DAuditMore.

Regards

Lindsay

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2013 August 09, Fri 00:01
To: eLink Recipient
Subject: Live Report to list group membership of a deleted user

Live Report to list group membership of a deleted user

Posted bywmader@co.jefferson.co.us (Mader, Walt) On 08-08-2013 18:58

Is there a Live Report that will give me the group membership of a deleted user? I'm using oracle, and am wanting to know what groups a deleted user was a member of.

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