Austin Agile DevOps

DevOps in the Cloud
posts - 70 , comments - 7 , trackbacks - 0

Publish TFS 2010 Last Work Item History Comment to Excel

Team Foundation Server 2010 does not support publishing history data to Excel. However, there is an easy work around to this problem.

However, this is limited to the last recorded History comment for a work item. This is what displays in the query return set when the History column is included.

  1. Create a query with History as a column
  2. Run the query
  3. Click the pulldown on the "Open in Microsoft Office" button
  4. Select "Send Query to Microsoft Outlook"

An email pops up with the data in a table that includes (unlike Excel) the last history comment for each work item. Simply copy the table to Excel and format.

It's not a comprehesive record, but it's very nice as a CCB meeting record of changes just made.

You can also use OneNote for this.

Print | posted on Tuesday, September 6, 2011 2:31 PM | Filed Under [ Agile SCM Talk Blog ]

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 

Powered by: