I wrote a little application to search our Visual Source Safe Database looking for checked out files. The application looks for files checked out for more than 2 weeks, then displays the check out date, user name and file. I can then use this information to contact the user and have them clean up their code check outs.
VB.NET 2008 Code is here (19 kb):
Microsoft VSS 6.0 API info is here: