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):
VSS_StatusSearch.zip
Microsoft VSS 6.0 API info is here:
http://msdn.microsoft.com/en-us/library/bb509341%28VS.80%29.aspx#vssauto_topic15