Monday, September 30, 2013

New Release of TFS Scorecard for TFS 2012.2

The TFS Scorecard is one of my oldest projects, starting back at the tfs2005 days and based on Microsoft TFS dogfooding queries. With each new TFS version there has been a new release of the TFS Scorecard, adopting to changes in TFS and adding features.

Dependency on the TFS database schema

The TFS Scorecard is based on the Microsoft TFS dogfooding queries against the TFS Collection database, and therefore has a dependency on the TFS database schema. As you might know the TFS database schema is not public and subject to change with every release. Historical those schema changes has been limited to the major version upgrades every second year, and Microsoft has provided us with new updated dogfooding queries for each release.

TFS2012 Update 2 schema changes

With the new release cadence of TFS releasing new features with quarterly updates, the speed of the schema changes has picked up also. Although not all schema changes affects the dogfooding queries, but the TFS 2012.2 update did. Not much, but enough to break TFS Scorecard report.
TFS Scorecard 2012.2 released
After an update on the queries was published, I’ve implemented it and pushed a new release compatible with the TFS 2012.2 release. You can find the release at
Note that the new release only works with TFS 2012.2 or later versions, if your running TFS 2012 RTM download the old TFS 2012 RTM release

New Features in the TFS Scorecard 2012.2
Apart from fixing the dogfooding queries, I’ve also managed to do some work on the Activity logging part. One of the major things is that I redone the translation of the logs to user friendly names in the report. Hopefully it will make the report easier to read for you.  I also introduced some structure to group different tools and releases together. Making it easier to spot both who on VS 2008, 2010 and 2012 and at the same time be able to drill down to the different 2012.x updates.

Future directions of the TFS ScorecardA lot have happened since 2005, new report and visualization tools, clouds and new access methods for consuming data, and the new release cadence of TFS. It got me thinking about the future for the TFS Scorecard. Perhaps it would be time to split the TFS Scorecard report into independent peace’s and even moving some of the pieces to other technical solutions. Nothing is decided yet, so If you have any thoughts or ideas on this, I would appreciate the feedback.


  1. Hello Mattias ,

    Does this new set of TFS scorecards works with 2013 as well ?


  2. Sorry for the late reply, Yes It does...

  3. Hello Mattias,

    I am having problems getting this to work on TFS 2012 Update 2. I have downloaded this latest tool set.
    An error has occurred during report processing. (rsProcessingAborted)
    Query execution failed for dataset 'TfsVersionControlTrend'. (rsErrorExecutingCommand)
    Invalid object name 'Tfs_Configuration.dbo.tbl_Identity'.

    Any suggestions? Kind regards, Carol

  4. Hello Mattias,

    I tried this also in TFS 2013,,,and got these errors during the upload of the TFS Scorecard.rdl file (TFSScoreCardReport 2012_2.rdl)
    Error while loading code module: ‘TfsScorecard.Utilities, Version=, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'TfsScorecard.Utilities, Version=, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingCodeModule) Get Online HelpError in class instance declaration for class TfsScorecard.Utilities.HeatMap: [BC30002] Type 'TfsScorecard.Utilities.HeatMap' is not defined. (rsCompilerErrorInClassInstanceDeclaration) Get Online Help
    The BackgroundColor expression for the text box ‘txtWIAdoptation’ contains an error: [BC30451] Name 'TfsScorecard' is not declared. (rsCompilerErrorInExpression) Get Online Help
    The BackgroundColor expression for the text box ‘MTM_TestCoverage’ contains an error: [BC30451] Name 'TfsScorecard' is not declared. (rsCompilerErrorInExpression) Get Online Help
    The BackgroundColor expression for the text box ‘textbox53’ contains an error: [BC30451] Name 'TfsScorecard' is not declared. (rsCompilerErrorInExpression) Get Online Help

    Any suggestions? Kind regards, Carol