On a weekly basis, I need to generate a List of Files from my Visual Source Safe 6.0 server, which are in Checked-out State. The list should provide the Filename and the User ID which has checked-out the file.
Is there any command-line program which I can use to achieve the above objective? Or is there any external tool/utility to do this job for me?
SS.exe can be used for such purposes. It will be in the VSS install directory, there are a few configuration steps you need to do to set it up to run conveniently.
http://msdn.microsoft.com/en-us/library/5ws92cw2%28VS.80%29.aspx
I believe the specific command you are looking for is Status.
e.g. ss Status $/ -R
It is also possible to do this with vbscript, I have done so in the past but no longer have access to those scripts.
Here is a link to a post that speaks of doing something similar to what you want.
Also, here is a link to a utility that gives (mostly) real time change updates by monitoring changes to the journal file.