Finding objects checked out by disconnected users

[kirkwemple]

How can I find all the checked out objects by a disconnected user.  I cannot set up a search for this because the disconnected user has been deleted and cannot be used in the search criteria.   

[BenLoosli]

First mistake - NEVER delete a user from Windchill. Rename their account and change the password, removing them from all groups.

Read through these threads:

How do you manage users account who have left the company

Deleting Users

Or just search the Community for Deleted User.

[TomU]

Technically a disconnected user has not been deleted, at least not from Windchill itself.  Deleting a user from Windchill does not remove their name from the database.  You can still search for objects created/modified by them, even after their account has been deleted.

Disconnected users are treated differently (as you can see).  Since Windchill can't find a matching LDAP account, it refuses to list the disconnected users in participant administration or as search criteria.  You could either reconnect them to a valid LDAP account or you could use query builder to report on their checked out objects.

Take a look at these for more information on querying for checked out objects by user:

Resource for reporting

All Checked Out CAD Docs with Workspace and User (Mike Lockwood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-56287-253837-71801/Checked+Out+CAD+Docs+with+Workspac…

https://support.ptc.com/appserver/cs/view/solution.jsp?&n=CS232560

[kirkwemple]

Correct Tom.  These users are not deleted from Windchill.  They have a '(deleted)' appended to the username.  Thanks for the clarification and the links.

--Kirk

[TomU]

If the name says (deleted) after it, then they definitely have been deleted from Windchill (though not totally from the database).  Disconnected users will not show this suffix.  (They won't show up at all.)  Users who have been deleted this way may still have checked out objects, but normally as part of the deletion process their personal cabinet will be removed and all checked out work will be cancelled.

Just to make sure everyone is 100% clear, here are the differences between these two states:

Disconnected User

• Windchill is unable to locate the user's account in LDAP.  (either deleted from Windchill DS or moved/deleted in Active Directory)
• A flag is set on the user's account in the database listing them as disconnected.
• No changes are made to their workspaces, checked out work, etc.
• They will not be able to log in until their Windchill record is remapped to a valid LDAP account.

Deleted User

• A flag is set on the user's record in the database marking them as deleted.  (This can be reversed easily if necessary.)
• Normally their personal cabinet is deleted (workspaces, etc.) and any checked out work cancelled.
• If their user account exists in Windchill DS, it will be deleted.
• They are automatically removed from any groups.
• Any time their name appears, Windchill will automatically add the "(deleted)" suffix to their name.
• Windchill will still display their name for any objects they affected (history, created by, modified by, etc.)
• Advanced searches can still be performed using their username.