Transferring Ownership of items in LL

Scott_Herman_(webmadmin_-_(deleted))

On another discussion group in the Knowledge Center I did find code that works on changing ownership from a deleted user, but I don't want to transfer the deleted user's personal workspace. Sometimes the new owner's personal space is replaced with the deleted user's personal space. Do you know of code that will transfer all files except the person's personal workspace? Thanks.Code I found in the Knowledge Center posted by Bo Warburton (bo@opentext.com):Here is a series of SQL commands that will help pull out the ID of a user that has been deleted and change the ownership of objects to Admin, or any other user of your choice. You could use this as the basis for a LiveReport and a click-through sub-report.1) Get the ID numbers of deleted usersselect ID from KUAF where name like 'deleted_user%';-or-select name from KUAF where deleted=1;2) Change the ownership of objectsupdate DTree set CreatedBy=1000 and UserID=1000 where CreatedBy={result from #1}3) Change other tables that have info on the creator of the fileupdate DVersData set Owner=1000 where Owner={result from #1}

x-unileveruser11_-_(deleted)

If you run the following Query, this will list all the Personal Workspaces - as an aside, you can use the creation date to match to the creation date of the user - this will then give you the ID of their PW as long as they haven't renamed it :select * from dtree where name like "%Home%"Once you have the the ID, just add an :AND WHERE dtree.dataid<> [ the dataid of the PW]and this should exclude the PW from the 2nd query.