How to get git like statistics from TFS

Question

I've been working with TFS for a few months now and would like to get some basic statistics and make them available to our team. In git, i could retrieve statistics on "commit by author" and "commit by date" etc.

I'd like to show similar statistics from TFS (or from TeamCity).

Is this possible?

Answer 1

The easiest way I find for poking around in TFS statistics is to play with Excel reports - you can pivot on just about anything you can imagine. For a guide to getting started take a look at this blog post I wrote:

http://www.woodwardweb.com/vsts/getting_started.html

TFS provides a full data warehouse over the top of the regular repository data for you to dig into.

Answer 2

You can use the TFS API to create any queries you like. You can quite easily iterate through the changesets looking for all commits by a certain author, or commits in a certain date:

TfsTeamProjectCollection tpc = new TfsTeamProjectCollection(new Uri("http://tfsserver:8080/"));
tpc.EnsureAuthenticated();
VersionControlServer vcs = tpc.GetService<VersionControlServer>(); 

int latest = vcs.GetLatestChangesetId();
DateTime earliestDate = new DateTime(2011, 1, 1);
do
{
    var changeset = vcs.GetChangeset(latest);                
    if (changeset.CreationDate < earliestDate)
    {
        break;
    }
    // do analysis of the changeset here,
    // e.g. use changeset.Committer or changeset.Changes
} while (latest-- > 0);