Has anyone ever tackled a query to determine all documents which are owned by a deleted user?
Documents Owned by a Deleted User Posted bywalter.ruppar@capitalone.com (Ruppar, Walt)On 12/18/2014 02:20 PM Has anyone ever tackled a query to determine all documents which are owned by a deleted user? [To post a comment, use the normal reply function]Forum:Content Server LiveReports ForumContent Server:Knowledge Center
What is your end goal? Are you planning to update the owner? If you have the Records Management module there is built-in functionality to change the ownership of Content Server objects from a deleted user.
From the Content Server Admin Page > Records Management AdministrationChange Ownership
Julie
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, December 18, 2014 1:51 PMTo: eLink RecipientSubject: Re Documents Owned by a Deleted User
Re Documents Owned by a Deleted User
Posted bycolin.schmidt@mwv.com (Schmidt, Colin) On 12/18/2014 02:50 PM
Not difficult. You just need to know theKUAF.ID. You can write a query that'll return all Deleted Users (kuaf.type = 0 and kuaf.deleted = 1). then find the name and use the ID in a list that goes through the DTREEACL table accessing by DTREEACL.RIGHTID. You get the DataID and then back to the DTREE to get the name.
Colin J. Schmidt
Opentext Content Server Support Admin
colin.schmidt@mwv.com+1 804.444 5012 (Direct)
MWV501 South 5th StreetRichmond, VA 23219-0501mwv.com
On Thu, Dec 18, 2014 at 2:22 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:
Documents Owned by a Deleted User
Posted by walter.ruppar@capitalone.com (Ruppar, Walt) On 12/18/2014 02:20 PM
[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 (mwv.com) 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.
Topic:
Thanks for the responses. Sure it isn't a difficult query, however our volume of data is massive (~300k Deleted Users and ~74 Million Docs). The time to run the query is what I am concerned with.
The end goal with this is to provide a listing of documents with their associated deleted user to the business units to select a new owner. Then yes, we would be using the RM functions to switch ownership from the deleted user to the new user.
