TFS Reporting Recipes #2: Get Daily Values for a Date Range

Monday, October 22, 2012

Purpose One of the most commonly required features in a report is a list of the daily values of some metric over a range of dates (for example, how many open bugs were in the system at the end of the day for each day in the last month).  This query will retrieve these metric values for each day in the date range. Prerequisites TFS 2010 or higher @StartDate parameter – The beginning of the required date range @EndDate parameter – The end of the...
no comments

TFS Reporting Recipes #1: Get the Iteration Path/GUID for the Current Sprint

Wednesday, October 17, 2012

Purpose Many times you want to filter the contents of reports based on sprints or iterations (for example, the number of re-opened bugs in each sprint in the project).  In this case, you often want the default of the report filter to show the iteration path of the current sprint.  This query will retrieve the current sprint’s iteration path. Prerequisites TFS 2010 or higher The Scrum process template A @ProjectGUID  parameter – The GUID of the Team Project in which you’re interested ...
no comments

TFS Reporting Recipes #0: Introduction

Well, it’s been a while since I’ve last blogged and it’s time to get back into the rhythm!  In this series, which I’m calling TFS Reporting Recipes, I’d like to show some tricks, tips and other patterns that help me along when I’m writing reports for customers.  I almost always use the relational warehouse since I feel more comfortable in SQL than in MDX, so for the recipes I assume you’re in the Tfs_Warehouse database. Feel free to sound off in the comments if you have questions/issues that you’d like to see me address. Happy Reporting! ...
no comments