SQL to Return List of files currently checked out.

[netoguy]

Could anyone provide me the SQL statement to return a list of all the currently checked out files along with the date they were checked out and the user who has them checked out?

(I'm wanting to write a application that will send weekly reminders to any person that has files checked out for more than a certain length of time.)

Thank you!

[jclausius]

For Vault 3.5.1 and less, you'll need to know the the repository's current checkout list.

Code: Select all

SELECT name, currentcolistid FROM sgvault.dbo.tblrepositories

Using the Checkout List ID, select from items -

Code: Select all

SELECT * FROM sgvault.dbo.tblcheckoutlistitems WHERE colistid = <currentcolistid_from_above>