When I'm ready to perform vault maintenance, I found it useful to email my vault users a list of the documents they have checked out and where they're checked out.
To accomplish this I create a search favorite (CHECKED OUT REPORT) that uses a custom Search Result column set containing 3 columns:
- <Checked Out By>
- <Checked Out In>
I use the Search Tool (instead of embedded search) so that I can open the results in Excel (using the Excel Open search result icon at the top of the search tool).
Once I run the search and open the results in Excel, I select View, Macros, View Macrosand Run the SplitCells macro (macro attached).
This creates a named worksheet tab for each user with a list of their checked out files.
I found that this type of report helps me debug any check-in issues we typically encounter.