Auditor requested query

[behold]

Our internal auditors have requested data that will show them the userid of the person that checked files in. I have looked in the sgVault database and cannot find the table or tables that will return the requested data. Is a SQL query showing the requested information possible and if so, what is it?

SourceSafe version 5.1.2
SQL Server 2008

Thank you
Brian

[Beth]

Are they looking for a particular check in or all check ins?

[behold]

I believe since they didn't specify, they want all check-ins. I would like to know how to get both.

[Beth]

There are a couple of features already in place that should give you what you need without needing to use SQL queries.

You can perform a Show History on $ in a repository. In the window that opens, you have various filter option. If you only want check ins, instead of renames, moves, and so on, then click on Actions and uncheck all except check in. You can then also save the results as a .csv file is you need to show it in some other format.

Another place to see just recent check ins is in the Vault web client. Just go to the Source Control tab and click on Checkins.

If either of these don't provide you with what you need, then can you provide a few more details?