Quick Tool / SQL to see all checkouts

[IainMartin]

Is there a tool, or an sql command which i can run and input a username and see all of the files they have checked out in all repositories, I ask this as we often have employees leave, without us being notified, when i do eventually find this out, the machine they used has been recycled, and I need to check every repository (20 or so) to see what they have checked out and undo it.

A simple query i can build a asp front end on it, and get managers to check and ensure these files are checked in prior to the employee leaving

[lbauer]

We don't have a query readily available, but you can use the ClientAPI's ProcessCommandListCheckOuts command to list the checkouts in
a single repository.

You can download the Client API here:

http://sourcegear.com/vault/downloads.html