I would like to run a report or search for all checked-out files, including when the files were checked out. Is this possible out of the box?
Hi Chris, while you can run a search for all currently checked out files, out of the box it won't return you the date of their checkout. You can, however, get this information from the database.
Are you familiar with the EPDM Report Generator tool? If so, you can use the attached report to return the information you requested.
If you need help loading the query into the Report Generator, let me know.
If you prefer to query the database some other way (via Excel, for example) the query is pretty straightforward:
select lockpath as [PATH], filename as [FILE], lockdate as [CHECKOUT DATE], users.username as [USER] from Documents
join Users on documents.UserID = users.UserID
LockDate IS NOT NULL
Thanks Jeff! This is what I was looking for.
Retrieving data ...